MySQL Forums
Forum List  »  Merge Storage Engine

Merge tables and indexes
Posted by: Vinayak Javaly
Date: June 01, 2006 02:13PM

How efficiently do Merge tables use indexes?

Potential scenario -- 50 MyISAM tables (20 million rows each) merged into 1 Merge table. Each base table has a primary key on a BIGINT column.
1) If I retreive 1 record by primary key from the Merged table, will ONLY the index for the base table containing this row be searched?
2) Should I create an index on the Merge table on this BIGINT column?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Merge tables and indexes
7446
June 01, 2006 02:13PM
5089
June 01, 2006 06:48PM
5048
June 02, 2006 08:36AM
4499
June 02, 2006 09:43AM
4226
June 02, 2006 01:28PM
4078
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.