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 optimize
题目
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.
相似考题
更多“The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan ”相关问题
-
第1题：
Netact Configurator不包括()A.Editor
B.Optimizer
参考答案：B
-
第2题：
36、0b01011100>20的结果是True.
B -
第3题：
0b01011100＞20的结果是True.
A -
第4题：
假设所有类型的碱基替代速率都相同属于哪个模型？
A．Jukes and Cantor’s (JC) 模型
B．Kimura Two-Parameter (K-2) 模型
C．Four-Parameter 模型
D．Six-Parameter 模型
Jukes and Cantor’s (JC) 模型 -
第5题：
5、创建模型model，设置参数include_optimizer可以实现断点续训。
正确 -
第6题：
34、表达式 [] == None 的值为 True.
×