Discussion Board

EXPLAIN PLAN 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. The EXPLAIN PLAN results let you determine whether the optimizer selects a particular execution plan, such as, nested loops join. It also helps you to understand the optimizer decisions, such as why the optimizer chose a nested loops join instead of a hash join, and lets you understand the performance of a query. Prajakta Pandit 02-9-2017 01:54 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*