Explain plan [message #18777] |
Thu, 14 February 2002 00:00 |
krishna
Messages: 141 Registered: October 1998
|
Senior Member |
|
|
I'm trying to understand how to interpret the execution plan. Suggest me a select statement that will give me an output from the plan_table in an understandable fashion-i.e a select statement which will give me an output in an indented fashion.
|
|
|
Re: Explain plan [message #18796 is a reply to message #18777] |
Thu, 14 February 2002 07:31 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
select LPAD(' ',2*(level-1))||operation operation,
options,object_name,position
from PLAN_TABLE
start with id = 0 and statement_id = :STATEMENT_ID
connect by
prior id = parent_id and statement_id = :STATEMENT_ID
|
|
|