Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting the Execution Plan?
take a look at the expain plan facility
On Fri, 31 Jan 1997 13:26:57 +0100, Matthieu Exbrayat <exbrayat_at_lisiflory.insa-lyon.fr> wrote:
>I wonder myself is it possible to get the execution plan
>of a query, and then to understand it...
>Is this documented?
>Is it possible to get the plan of a query without executing it?
>(our aim is to study the plan to get a parallel execution plan
>via a 2 phases optimisation)
>
>Thanks for help
>
>--
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>~ Matthieu EXBRAYAT | ~
>~ LISI - INSA Lyon | e-mail : exbrayat_at_lisiflory.insa-lyon.fr
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Sat Feb 01 1997 - 00:00:00 CST