Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 8.1.7 SQL tuning
In addition to Valery's reading tip, you should know that the last table given *is* the driving table when using the rule-based optimizer, but it is not when using the cost-based optimizer. For more info, you should read up on optimization modes as well as hints (as Valery has suggested, it appears). In addition to the Oracle documentation, Richard Niemiec's book Oracle Performance Tuning Tips & Techniques is someplace you could look for related information.
Hope this helps,
Chris
"Jon" <jonathan.harvey_at_cerillion.com> wrote in message
news:1001934612.4575.0.nnrp-07.c3adc012_at_news.demon.co.uk...
> I have (mistakenly) been reading the documentation and it seems to imply
> that the order at which you specify the joins affects the performance
> because it specifies to Oracle which table is to used as the driving table
> for the join. Can anyone please correct me or add details to this
seemingly
> surprising feature. Thanks in advance.
>
>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=