| Subject | Re: Re: [firebird-support] Re: GROUP BY and JOINs | 
|---|---|
| Author | Pavel Menshchikov | 
| Post date | 2005-07-02T06:55:11Z | 
Hello Arno,
Thanks for the explanation.
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?
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com
            Thanks for the explanation.
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?
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com