12,673
回編集
差分
ナビゲーションに移動
検索に移動
FROM F[[R]]OM PLAN_TABLE
START STA[[R]]T WITH id = 0
ORDER O[[R]]DE[[R]] BY id
編集の要約なし
==EXPLAIN PLAN==
[[Oracle]] | {{category [[Category:DBパフォーマンス}}]]
@$ORACLE_HOME/RDBMS/ADMIN/UTLXPLAN.[[SQL]]
truncate table plan_table;
SELECT cardinality "Rows[[R]]ows",
lpad(' ',level-1)||operation||' '||
options||' '||object_name "Plan"
CONNECT BY prior id = parent_id
AND prior statement_id = statement_id
AND statement_id = 'plan_test'
----
{{include_html [[banner_html]], "!Oracle"}}
© 2006 矢木浩人
