Home » SQL & PL/SQL » SQL & PL/SQL » Explain plan
Explain plan [message #18777] Thu, 14 February 2002 00:00 Go to next message
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 Go to previous message
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
Previous Topic: Handling ASCII values in ORACLE like ^M
Next Topic: Improve Performance of SQL
Goto Forum:
  


Current Time: Thu Sep 23 12:31:43 CDT 2021