Hi,

> AB> I'll try to describe it:
> AB> Stored Procedures/Aggregate streams/UNION streams/sorted
> AB> streams are put on the top site of the
> AB> "execution PLAN" inside an INNER JOIN section. Regardless if
> AB> there's any dependency with an other
> AB> stream.

> Is there a reason to leave it as it is? Or will dependencies change
> the join order in FB2?

Time, it needs some more investigation and a solution. It has the attention, but not for FB2.

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