(Iggy Fernandez) An enduring Oracle myth is that EXPLAIN PLAN and AUTOTRACE show the execution plan. However, the only way to find the right query plan is to actually execute the query and get the execution plan from V$SQL_PLAN using DBMS_XPLAN.DISPLAY_CURSOR.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help