EXPLAIN PLAN & AUTOTRACE
Published July 26, 2025
By Sai Sree Ram Gundepudi
EXPLAIN PLAN
Displays the execution plan of a SQL statement.
EXPLAIN PLAN FOR SELECT * FROM employees WHERE department_id = 10;
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);AUTOTRACE
Shows the execution plan and statistics.
SET AUTOTRACE ON;
SELECT * FROM employees WHERE employee_id = 100;