MySQL Forums
Forum List  »  Merge Storage Engine

Re: Merge table performance
Posted by: Ingo Strüwing
Date: July 20, 2005 12:58AM

Right. I would like to add that MySQL uses one index only, but you have three conditions. So it uses one index to pick matching rows from the tables, but has to pick one after the other until the other conditions are fulfilled too. This is kind of a jumping table scan.

Alastairs idea to create an index over all three columns should make the queries very fast.

Options: ReplyQuote


Subject
Views
Written By
Posted
9839
July 19, 2005 09:13AM
5103
July 19, 2005 11:37PM
Re: Merge table performance
4832
July 20, 2005 12:58AM
4728
July 21, 2005 01:38AM


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.