Re: How to SHOW a PLAN?

From: Andrew Babb <andrewb_at_mail.com>
Date: Sat, 01 May 1999 09:29:52 +0800
Message-ID: <372A5910.1C8EFD55@mail.com>

Ken,

A number of options for this one,

If simple SQL statement, then you could use the EXPLAIN PLAN command of SQL*Plus or even the 'set autotrace on explain'. Both of these require the PLAN_TABLE to be created, the second one is slightly easier since the plan is automatically outputted after the data result is outputted.

Other options are to use SQL TRACE, and then use TKPROF to analyze the data.

Rgds
Andrew

Ken wrote:

> How do I find the execution plan of an SQL query?
>
> *~~~~~~~~~~~~~~~*
> * Ken *
> * ICQ 34477742 *
> * not1.demon.co.uk *
> *~~~~~~~~~~~~~~~*
Received on Fri Apr 30 1999 - 20:29:52 CDT