MySQL Forums
Forum List  »  Merge Storage Engine

Re: Merge tables and indexes
Posted by: KimSeong Loh
Date: June 01, 2006 06:48PM

It will scan the index from all the merged MyISAM tables. MySQL does not know which table contain the value you are searching. Reason being that Merge table does not create any extra index, it reuses the original index in the underlying MyISAM tables.

When you create the Merge table, you have to create it with exactly the same structure as the underlying MyISAM tables including the indexes, the only exception is to use a normal index in place of primary key and unique key.

Options: ReplyQuote


Subject
Views
Written By
Posted
7446
June 01, 2006 02:13PM
Re: Merge tables and indexes
5088
June 01, 2006 06:48PM
5048
June 02, 2006 08:36AM
4498
June 02, 2006 09:43AM
4226
June 02, 2006 01:28PM
4077
June 06, 2006 11:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.