Subject Re: [firebird-support] another make my query faster question
Author Ann W. Harrison
Alexandre Benson Smith wrote:
>>
> On FB 1.5 and earlier an outer join forces the optimizer to use the
> table as the first relation on the join order.... Really don't know how
> it will go with FB 2.0 :-/
>

Unless I've lost the thread of the discussion (which happens
pretty often) the order of table access with outer joins is
not an optimizer issue but a logic issue.

Regards,


Ann