Click to See Complete Forum and Search --> : Explain Plan


preetham
09-08-2004, 03:56 AM
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
09-08-2004, 05:01 AM
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
09-13-2004, 03:08 AM
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