1
Reply

What does an EXPLAIN PLAN statement does?

Anantha Narayanan

Anantha Narayanan

Mar 26, 2007
6.3k
0

    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.

    Santhosh Kumar Gundla
    March 28, 2007
    0