==Oracle 10gR2実行計画の確認==
[[Oracle]]{{category 編集中}}{{category DBパフォーマンス}}
===SQL Plus===
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19207-02/optimops.htm#967766
====実行例====
SQL> > set lin 1000 SQL> > set autotrace trace explain SQL> > select * from oratest.google_content_report
2 left outer join (
3 select proc_time, count(proc_time) ac from oratest.httpd_access_log