Hi,

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

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info