No, it is only a trick to bump out indexes you don't want, leaving in ones
you do want.

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

----- Original Message -----
From: "Nando Dessena" <nandod@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, February 22, 2001 1:25 AM
Subject: Re: [ib-support] Query Plan


> Jason,
>
> > 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.
> >
> > The optimizer cannot use an index for a computed value in a
comparison...
>
> this is interesting, I never thought about that.
> Anyway, I need to have the optimizer use the one meaningful index.
> Your solution would make it not use any indexes (indices?), wouldn't it?
> Thanks
> --
> ____
> _/\/ando
>