MySQL Forums
Forum List  »  Optimizer & Parser

Re: Two possible indexes in simple select but none is used
Posted by: Yogesh Salvi
Date: December 13, 2006 04:41AM

Hello,

Try this one ,
select * from FOO where id = 0
UNION
select * from FOO where unique_id = 'blah';

This is the better way to optimize OR type query.

Thanks,
Yogesh Salvi

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Two possible indexes in simple select but none is used
1905
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.