What does an EXPLAIN PLAN statement does?
Anantha Narayanan
Select an image from your device to upload
The EXPLAIN PLAN statement displays execution plans chosen by the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements. A statement's execution plan is the sequence of operations Oracle performs to run the statement.