Re: Driving table

From: <michael_bialik_at_my-deja.com>
Date: Tue, 25 Jan 2000 20:47:13 GMT
Message-ID: <86l24g$ukb$1@nnrp1.deja.com>

Hi.

Check EXPLAIN PLAN of your statement.

Michael.

In article <388DD5EA.8CB0D6D1_at_hotmail.com>, s_c_99_at_hotmail.com wrote:
> 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 25 2000 - 14:47:13 CST