See the Exhibit:In the CUSTOMERS_OBE table, when the value of COST_STATE_PROVINCE is CA, the value of COUNTRY_ID is US.
Posted: Sun Jun 11, 2023 3:50 pm
See the Exhibit:In the CUSTOMERS_OBE table, when the value of COST_STATE_PROVINCE is CA, the value of COUNTRY_ID is US. See the exhibit 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. Set the STATISTICS_LEVEL parameter to TYPICAL
B. Change the STALE_PERCENT value for the CUSTOMERS_OBE table
C. Set the OPTIMIZER_USE_PENDiNG_STATISTICS parameter to FALSE
D. Create extended statistics for the CUST_STATE_PROVINCE and COUNTRY_ID columns
A. Set the STATISTICS_LEVEL parameter to TYPICAL
B. Change the STALE_PERCENT value for the CUSTOMERS_OBE table
C. Set the OPTIMIZER_USE_PENDiNG_STATISTICS parameter to FALSE
D. Create extended statistics for the CUST_STATE_PROVINCE and COUNTRY_ID columns