Subject Re: [ib-support] Query Plan
Author Jason Wharton
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

----- Original Message -----
From: "Nando Dessena" <nandod@...>
To: <>
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