Re: Does Explain Plan really execute the query?

From: Mark D Powell <mark.powell_at_eds.com>
Date: 17 Jul 2002 11:24:36 -0700
Message-ID: <178d2795.0207171024.682cbd0@posting.google.com>

"David" <david_at_yahooo.com> wrote in message 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

No, explain plan does not execute the query in order to display the plan, but the SQLPlus command autotrace does.

See the chaper on explain plan in the Performance and Tuning Manual for more information.

HTH -- Mark D Powell -- Received on Wed Jul 17 2002 - 13:24:36 CDT