多选题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

题目
多选题
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.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案