「Oracle EXPLAIN PLAN」の版間の差分
ナビゲーションに移動
検索に移動
| 1行目: | 1行目: | ||
==EXPLAIN PLAN== | ==EXPLAIN PLAN== | ||
| − | [[Oracle]] | | + | [[Oracle]] | [[Category:DBパフォーマンス]] |
| − | @$ORACLE_HOME/RDBMS/ADMIN/UTLXPLAN.SQL | + | @$ORACLE_HOME/RDBMS/ADMIN/UTLXPLAN.[[SQL]] |
truncate table plan_table; | truncate table plan_table; | ||
| 9行目: | 9行目: | ||
| − | SELECT cardinality " | + | SELECT cardinality "[[R]]ows", |
lpad(' ',level-1)||operation||' '|| | lpad(' ',level-1)||operation||' '|| | ||
options||' '||object_name "Plan" | options||' '||object_name "Plan" | ||
| − | + | F[[R]]OM PLAN_TABLE | |
CONNECT BY prior id = parent_id | CONNECT BY prior id = parent_id | ||
AND prior statement_id = statement_id | AND prior statement_id = statement_id | ||
| − | + | STA[[R]]T WITH id = 0 | |
AND statement_id = 'plan_test' | AND statement_id = 'plan_test' | ||
| − | + | O[[R]]DE[[R]] BY id | |
---- | ---- | ||
| − | {{include_html banner_html, "!Oracle"}} | + | {{include_html [[banner_html]], "!Oracle"}} |
2020年2月16日 (日) 04:30時点における版
EXPLAIN PLAN
Oracle |
@$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"}}
© 2006 矢木浩人
