{"status":true,"html":"
165.View the Exhibit exhibit1.<\/p>\r\n\r\n
\u00a0<\/p>\r\n\r\n
In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is \"CA\", the value of\u00a0COUNTRY_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?<\/p>\r\n\r\n
A. Change the STALE_PERCENT value for the CUSTOMERS_OBE table.<\/p>\r\n\r\n
B. Set the STATISTICS_LEVEL parameter to TYPICAL.<\/p>\r\n\r\n
C. Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERS_OBE columns.<\/p>\r\n\r\n
D. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.<\/p><\/p>\n <\/div>\n