Hi Sean,

> > > Are you sure that your getting the exact same
> results?

Yupe, I got exactly the same results. It's strange
that IB choose to use both indexes, and it performed
very poorly then. But when I specifically told IB to
use 1 index, it works like a champ.

> What I do is add a +0 to date columns and this
> effectively drops the index
> and then a plan is not needed. With strings you can
> use || '' and this will
> accomplish the same thing.

Hi Jason, but if the index is not used, wouldn't it
slow down the query? I only take less than 10% of the
total rows in a table so I think index is needed in my
case.

regards,
Sindu

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/