Subject Re: [firebird-support] Re: where field = any
Author Miroslav Penchev
On Thu, 21 Oct 2004 02:16:02 -0300, Alexandre Benson Smith
<iblist@...> wrote:

> Miroslav Penchev wrote:
>> I don't thing so. I thing that query optimizer will see that
>> 1=:ACTIVE_FILTER when ACTIVE_FILTER is 0 is always false and will not
>> scan
>> any record for that.
>> Cheers,
> No, AFAIK the optimizer doesn't compute "constants" expression before
> execute the statement, it will be evaluated for each row. If it does it
> the trick to put an "or something" to force optimizer ignore the bad
> indices will not work. :-)

I know that for IB 6.0 Open source. Is that issue ("constant" expression
in WHERE) is planed to be solved in future releases in FB?

Miroslav Penchev