View the Exhibit exhibit1. In the CUSTOMERS_OBE table, when the value of
CUST_STATE_PROVINCE is “CA”, the value of COUNTRY_ID is “US.” View the Exhibit
exhibit2 to examine the commands and query plans. The optimizer can sense 8 rows
instead of 29 rows, which is the actual number of rows in the table. What can you do to
make the optimizer detect the actual selectivity?
A.
Change the STALE_PERCENT value for the CUSTOMERS_OBE table.
B.
Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.
C.
Set the STATISTICS_LEVEL parameter to TYPICAL.
D.
Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERS_OBE
columns.