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

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

----- Original Message -----
From: "Nando Dessena" <nandod@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, February 21, 2001 9:56 AM
Subject: Re: [ib-support] Query Plan


> Sean,
>
> > Are you sure that your getting the exact same results?
>
> I keep running into that same behaviour from time to time. Somehow IB
> just goes and collects every available index slowing it all down.
> I have never been able to find a clue...
> --
> ____
> _/\/ando