Getting the Execution Plan?

From: Matthieu Exbrayat <exbrayat_at_lisiflory.insa-lyon.fr>
Date: 1997/01/31
Message-ID: <32F1E511.41C67EA6@lisiflory.insa-lyon.fr>#1/1

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 Fri Jan 31 1997 - 00:00:00 CST