Re: Two possible indexes in simple select but none is used

[Yogesh Salvi]

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