The main difference have three points:
1. Explain plan for : generate the execution plan not the actually execution plan will happen on database. the actually plan should query v$sql_plan view.
Autotrace: generate the actually execution plan
2. Explain plan for: only work at query statement that is SELECTs;
Autotrace: works for any SQL and DML statements
3.Explain plan for: you have to use utlxpls.sql to have the readable report for the execution plan.
Autotrace: automaticaly show the execution plan for SQL statements.
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/94166/viewspace-996464/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
