EXPLAIN PLAN Statement

Display the execution plan for an SQL statement.

Syntax:

   EXPLAIN PLAN [SET STATEMENT_ID = 'text']
      FOR statement;

   EXPLAIN PLAN [SET STATEMENT_ID = 'text']
      INTO [schema.]table@dblink
         FOR statement;

"Nobody expects the Spanish Inquisition!!!" - Monty Python

Related Commands:

ANALYZE
INSERT
SELECT
UPDATE

Related Views:

DBA_SNAPSHOTS        ALL_SNAPSHOTS        USER_SNAPSHOTS
DBA_ALL_TABLES       ALL_ALL_TABLES       USER_ALL_TABLES
DBA_TABLES           ALL_TABLES           USER_TABLES         TAB
DBA_VIEWS            ALL_VIEWS            USER_VIEWS

DICTIONARY
DICT_COLUMNS
V$EXECUTION

Equivalent SQL Server command:

dta Utility