Difference Between Explain Plan and Execution Plan in Oracle
So i started exploring plan_table and voilathere it was. By Richard Niemiec on April 20 2013. Sql Developer 4 2 Oracle Execution Plans More Columns Available There are multiple methods to generate an SQL plan. . EXPLAIN PLAN command generates the execution plan and stores the plan in PLAN_TABLE table. It shows the following information. A statements execution plan is the sequence of operations Oracle performs to run the statement. The plan displayed by explain plan is the one that the database thinks or predicts it will use to run the query whereas the plan displayed by autotrace is the plan that was actually used to run the query at. These are the execution plan or execution path for SQL query execution set by oracle optimizer. The Oracle explain plan is nothing but the execution plan in readable format with using which user can check analyse and tune the SQL queries. AUTOTRACE easy option. The actual exe...