MySQL Forums
Forum List  »  Optimizer & Parser

Re: Two possible indexes in simple select but none is used
Posted by: KimSeong Loh
Date: November 28, 2006 06:27PM

Each table access is limited to 1 index, with the OR 1 index cannot get the result.

Upgrade to MySQL 5.0 and it can use the index merge optimization.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Two possible indexes in simple select but none is used
1948
November 28, 2006 06:27PM


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.