[firebird-support] Re: Common Table Expressions ( “WITH ... AS ... SELECT”)

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

23.01.2015 15:30, masb...@za-management.com 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