Hi,

> > > > PLAN JOIN(JOIN(identityname NATURAL, InvHead INDEX (...)), acctname
> > > INDEX
> >
> > What PLAN does the engine use with :
> >
> > select identityname.idref
> > from identityname
> > inner join InvHead on identityname.idref = invhead.idref
> > left join acctname on invhead.invheadref = acctname.invheadref
> > where invhead.invheadref = 25809
>
> For this SQL it uses the first of the 3 you supplied above.

Okay, but can you POST the PLAN. I'm curious what indices are used.

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://80.126.130.81