In the CUSTOMERS table, the values in the CUST_STATE column are dependent on the values in the
COUNTRY_ID column. You want to make the optimizer aware of this dependency when these columns are used
together in WHERE clause predicates that contain equalities or in-lists.
Which two methods achieve this? (Choose two.)
A.
gathering statistics on the CUSTOMERS table and its dependent objects, and then locking the statistics
B.
using SQL plan directives to generate an optimal plan
C.
setting the dynamic statistics level to 4 and setting the OPTIMIZER_USE_PENDING_STATISTICS
initialization parameter to true
D.
creating column group statistics, regathering statistics, and ensuring that histograms exist on both these
columns