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

> 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.