Re: Getting the Execution Plan?

Explain plan command should get you started.

I also bought a book from o-reiley which has a huge chapter dealing with explain plans an how to interpret.

>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)
Received on Tue Feb 04 1997 - 00:00:00 CST