Explain plan for and autotrace diffrence

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博客 ” ，链接：http://blog.itpub.net/94166/viewspace-996464/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/94166/viewspace-996464/