Name the tool for tuning SQL statements.

Options
- TUNEUP SYS
- EXPLAIN SYS
- DB_TUNEUP
- EXPLAIN PLAN


CORRECT ANSWER : EXPLAIN PLAN

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


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement