Multiple choice technology databases

What is the default value for the OPTIMIZER_MODE initialization parameter?

  1. FIRST_ROWS

  2. ALL_ROWS

  3. CHOOSE

  4. COST

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The OPTIMIZER_MODE initialization parameter in Oracle defaults to CHOOSE. This setting allows the optimizer to choose between rule-based and cost-based optimization depending on whether statistics are available for the tables in the query.