| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
