| Subject | Re: AW: [firebird-support] Re: Any available documentation on Plan Analyzer? |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-02-05T20:52:39Z |
Steffen Heil wrote:
determines the order of inner joins. The optimizer uses the same
calculation you used.
Regards,
Ann
>Not the order in your query, but the order chosen by the optimizer
> But the intermediate result has 10^6 as many records.
>
> The order of JOIN expressions determins assoiciativity (in my example the
> parenthesis).
determines the order of inner joins. The optimizer uses the same
calculation you used.
Regards,
Ann