多选题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 performed by the optimizer in this scenario?（）AThe optimi
题目
多选题
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 performed by the optimizer in this scenario?（）
A
The optimizer adds the new plan to the plan history.
B
The optimizer selects the new plan for the execution of the SQL statement.
C
The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
D
The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
E
The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
相似考题
参考答案和解析
正确答案：
E,A
解析：
暂无解析