Subject Re: [firebird-support] Determining Join Order
Author Ann W. Harrison
Ann W. Harrison wrote:
> Yes. That's what the optimizer attempts to do. However, it
> does not do the transformations necessary to convert a subquery
> to a join - transformations that become quite complex when the
> subquery can return a null set.

I should probably have mentioned that it can't change the order
of outer joins either.