MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Two possible indexes in simple select but none is used
3359
Ozkan Mehmedali
November 28, 2006 10:40AM
Re: Two possible indexes in simple select but none is used
1977
KimSeong Loh
November 28, 2006 06:27PM
Re: Two possible indexes in simple select but none is used
1936
Yogesh Salvi
December 13, 2006 04:41AM


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.