Explain Plan

[preetham]

Hi
Will Explain plan take same amount of time to run,if it is running for a query where this query is taking 94 min to execute.

please give me details about it.

regards
preetham

[Srinivas_Sharma]

Hi

U can use explain plan just to generate the path which the optimizer will take if u run the query.

So u r not actually running the query but determining the path.


Srini

[hrishy]

Hi

In sqlplus u can do

set autotrace trace only

and tryu running the query to get just the query plan minus the results

regards
Hrishy