Summary: SQLPLUS under the automatic display, look at their statements or implementation plan will be implemented. Especially in the implementation of the UPDATE / DELETE statement, please do note, ORACLE is the first implementation of the script also shows that implementation of the plan, even with set autotrace on traceonly explain;
Recommended at this time, or run EXPLAIN PLAN FOR PL / SQL and other third-party tools
3, the third tool of view the implementation plan
If the PL / SQL using select query execution plan display, which only need to enter SQL WINDOWS window query SQL statement, then select the button F5 or the menu TOOLSDD> Explain Plan button on the menu in the implementation of program window view of the statement execution plan.
Statement in TOAD SQL in the implementation of the current window, select the bottom of the page that you can view Explain PlanTAB statement to execute the implementation plan information.
set autotrace on explain;
explain plan for select * from emp where