When (or after) creating a merge type table, you do need to create all
indexes just like you've created them for your regular tables.
This however will NOT result in physically creating any additional indexes,
but the indexes of the real tables will be used instead. Therefore no extra
index maintenance is needed.
Charlie
>From: "Jay Blanchard" <jay.blanchard@stripped>
>To: <mysql@stripped>
>Subject: INDEXing on MERGED TABLES
>Date: Wed, 8 May 2002 09:19:39 -0500
>
>Howdy group!
>
>Having now merged some rather large tables and having read the
>documentation
>http://www.mysql.com/doc/M/E/MERGE.html "It doesn't need to maintain an
>index of its one. This makes MERGE table collections VERY fast to make or
>remap. Note that you must specify the key definitions when you create a
>MERGE table!. "
>
>It is saying that it "doesn't need" to maintain an index. Does indexing
>effect MERGEd tables?
>
>Thanks!
>
>Jay
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread108353@stripped>
>To unsubscribe, e-mail
><mysql-unsubscribe-charlie235=hotmail.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
