Re: Driving table

rule based optimizer:
if the optimizer is unable to find an effficient sequence, the last table will be driving, and the rest will be handled in reverse sequence, so from right to left
Cost Based optimizer:
Table will be dealt with from left to right, the leftmost table will be driving.
If you want to influence this, place the tables in what you consider to be the correct sequence
and use the /*+ ordered */ hint.

Hth,

--
Sybrand Bakker, Oracle DBA
SC <s_c_99_at_hotmail.com> wrote in message news:388DD5EA.8CB0D6D1_at_hotmail.com...
> If I have a complex SQl having atleast six seven
> tables in 'from' clause, how can I determine
> which is the driving table and the second driving table
> and the third and so on??
> I want to know this from performance tuning point of view.
> (running on Oracle 7.3.3.6, Open VMS).
>
> Thanks.
>
> SC
> S_C_99_at_hotmail.com
>
Received on Tue Jan 25 2000 - 12:27:08 CST