Subject Re: [firebird-support] Re: Query Optimization (Arno, where are you?)
Author Arno Brinkman

> > I think, that this is a problem of the SQL optimizer for the
> > development group. Should I post it there?
> Maybe, but let's see if Arno gets attracted to the revised title and
> has some input. It will be interesting to see if he can tell the
> difference between your two apparently identical statements.

When reading the thread i'm afraid Juan hit a bug introduced in FB1.5.1
This caused unneeded fetches for relations which depends on relations with a
OR condition bound to it and no index could be used by that OR condition.
This will be fixed in the next Firebird releases.

Arno Brinkman

Firebird open source database (based on IB-OE) with many SQL-99 features :

Support list for Interbase and Firebird users :

Nederlandse firebird nieuwsgroep :