The table order is used when you use the rule based optimizer.
If the optimizer is set to choose, then it will use the rules based
optimizer if no statistics are on the table.
If you are using the cost based optimizer, then make sure that all the
tables which are affected by the query have been recently analyzed.
Analyzing tables is something which need sto be done on a regular basis .
Noodles wrote in message <20000123153526.03693.00001772_at_ng-fl1.aol.com>...
>A question... Doesn't the table order only have an effect when your using
>rule-based optimization ?
>
>Cliff
>
>>Try putting the smallest tables last in the from clause. In our
development
>>environment we went from over a minute to under a second by doing this.
>
>
Received on Mon Jan 24 2000 - 07:11:25 CST
