Which two methods achieve this? (Choose two.)
A. creating column group statistics, regathering statistics, and ensuring that histograms exist on both these columns
B. setting the dynamic statistics level to 4 and setting the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to true
C. gathering statistics on the CUSTOMERS table and its dependent objects, and then locking the statistics
D. using SQL plan directives to generate an optimal plan
Answer:A
Which two methods achieve this? (Choose two.)
A. creating column group statistics, regathering statistics, and ensuring that histograms exist on both these columns B. setting the dynamic statistics level to 4 and setting the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to true C. gathering statistics on the CUSTOMERS table and its dependent objects, and then locking the statistics D. using SQL plan directives to generate an optimal plan
Explanation: Explanation/Reference: