!!!EXPLAIN PLAN
[Oracle]{{category DBパフォーマンス}}

 @$ORACLE_HOME/RDBMS/ADMIN/UTLXPLAN.SQL
 
 truncate table plan_table;
 explain plan set statement_id='plan_test' for
 [SQL_Statement]
 
 
 SELECT cardinality "Rows",
 lpad(' ',level-1)||operation||' '||
 options||' '||object_name "Plan"
 FROM PLAN_TABLE
 CONNECT BY prior id = parent_id
 AND prior statement_id = statement_id
 START WITH id = 0
 AND statement_id = 'plan_test'
 ORDER BY id
----
{{include_html banner_html, "!Oracle"}}