DBMS_XPLAN

Obtaining Execution Plan in Oracle

What is execution plan? An execution plan describes the list of operations which are performed by SQL Engine for SQL statement. The order of operations and their implementation is decided by the oracle query optimizer. An execution plan also shows