How to read Oracle Explain Plan

The EXPLAIN PLAN statement displays execution plans chosen by the Oracle optimizer.A statement’s execution plan is the sequence of operations Oracle performs to run the statement.execution plans are read inside-out.if there are two statements at the same level, the first statement is executed first. You can use “Explain plan statement for this.” which should be … Continue reading How to read Oracle Explain Plan