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.

时间:2022-09-28 22:29:44 所属题库:1Z0-060题库

相似题目