Subject Re: Common Table Expressions ( “WITH ... AS ... SELECT”)
Author Dmitry Yemanov
23.01.2015 15:30, masberg@... wrote:
>
> Dimitry, why is it so that for every outer join the inner part is always
> re-evaluated?

Because there are no alternative algorithms for outer joins in Firebird
(yet).

> And if I switch to an inner join, this could be avoided?

Yes, it could. But if you really needed an outer join, then it can
hardly be replaced with an inner one.


Dmitry