My Training Notes & Blog

EXPLAIN PLAN & AUTOTRACE

Published on: July 26, 2025 | Published by: Sai Sreeram 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);

Shows the execution plan and statistics.

SET AUTOTRACE ON;
SELECT * FROM employees WHERE employee_id = 100;