> > 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.

That is just a trick to get it to not use particular indexes that it doesn't
need. Of course there are other appropriate indexes which remain in the
plan.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com