Subject | Re: [firebird-support] another make my query faster question |
---|---|
Author | Ann W. Harrison |
Post date | 2006-07-13T15:40:53Z |
Alexandre Benson Smith wrote:
pretty often) the order of table access with outer joins is
not an optimizer issue but a logic issue.
Regards,
Ann
>>Unless I've lost the thread of the discussion (which happens
> 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 :-/
>
pretty often) the order of table access with outer joins is
not an optimizer issue but a logic issue.
Regards,
Ann