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