The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are…

Question

Options

• AThe optimizer adds the new plan to the plan history.
• BThe optimizer selects the new plan for the execution of the SQL statement.
• CThe optimizer adds the new plan to the SQL plan baseline as an accepted plan.
• DThe optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
• EThe optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with

• A
  83% (25)
• B
  10% (3)
• C
  3% (1)
• D
  3% (1)

No community discussion yet for this question.