Difference Between Execution Plan and Explain Plan in Oracle
EXPLAIN PLAN output shows how the database would have run the SQL statement when the statement was explained. Just as in the driving example above Oracle may use a different route than the one it predicted. Explain Plan The main difference between the AUTOTRACE and EXPLAIN PLAN commands in Oracle is that AUTOTRACE actually executes the query in the way TRACE does and automatically queries the plan table whereas EXPLAIN PLAN does neither. . The SQL is identical so I would expect that the SQL explain plan would not be different. A statements execution plan is the sequence of operations Oracle performs to run the statement. An execution plan describes the steps it actually took. My favorite column other_xml. Select from emp where empno736. An explain plan predicts how Oracle will process your query. But I have also read that Execute plan is the plan which Oracle Optimizer intends to use for the query and actu...