网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which three statements are true about adaptive SQL plan management?（）
A
It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
B
The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
C
It adds new, bettor plans automatically as fixed plans to the baseline.
D
The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
E
The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which three statements are true about adaptive SQL plan management?（）AIt automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.BThe optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.CIt adds new, bettor plans automatically as fixed plans to the baseline.DThe non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.EThe non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.” 相关考题
热门标签
最新试卷
