Before to execute a source program, you must compile it.
Execution plan is the result of the compilation. Execute comes after that,
so you can get the execution plan without running the query.
HTH.
--
Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove .spammenot from my address
"David" <david_at_yahooo.com> a écrit dans le message de news:
ah3uv6$kob2_at_imsp212.netvigator.com...
> Hi all,
>
> When I use Explain Plan to obtain the execution plan of a query, does
> this query actually execute? If not, how Oracle knows the execution plan
of
> a query?
>
> Thanks,
> David
>
>
Received on Wed Jul 17 2002 - 10:05:17 CDT
