Definitions for "EXPLAIN PLAN"
Keywords:  query, oracle, dml, lengthy, sql
an access path determined by the query optimizer
a representation of the access path that is taken when a query is executed within Oracle
A SQL statement that enables examination of the execution plan chosen by the optimizer for DML statements. EXPLAIN PLAN causes the optimizer to choose an execution plan and then to put data describing the plan into a database table.