Which three statements are true about adaptive SQL plan management?
A.
The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
B.
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.
C.
It automatically performs verification or evolves non-accepted plans, in
COMPREHENSIVE mode when they perform better than existing accepted plans.
D.
The non-accepted plans are automatically accepted and become usable by the optimizer
if they perform better than the existing accepted plans.
E.
It adds new, bettor plans automatically as fixed plans to the baseline.
BCD