12,673
回編集
差分
ナビゲーションに移動
検索に移動
ページの作成:「==EXPLAIN PLAN== [Oracle]{{category DBパフォーマンス}} @$ORACLE_HOME/RDBMS/ADMIN/UTLXPLAN.SQL truncate table plan_table; explain plan set statement_id=…」
==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"}}
[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"}}
© 2006 矢木浩人
