Oracle
1Z0-054 · Question #20
The columns CUST_CITY, CUST_STATE_PROVINCE, and COUNTRY_ID are frequently used together in the WHERE clause of the queries. The CUSTOMERS table is a big table with 20 GB of data. You notice that the…
The correct answer is D. using the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and. See the full explanation below for the reasoning.
Question
The columns CUST_CITY, CUST_STATE_PROVINCE, and COUNTRY_ID are frequently used together in the WHERE clause of the queries. The CUSTOMERS table is a big table with 20 GB of data. You notice that the selectivity for these three columns varies from the selectivity that the optimizer calculates. What would you recommend to influence the selectivity calculated by the optimizer?
Options
- Acreating function-based indexes by concatenating all the columns
- Bupdating histogram statistics for these columns by using the
- Cusing the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and
- Dusing the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and
How the community answered
(35 responses)- A3% (1)
- B14% (5)
- C6% (2)
- D77% (27)
Community Discussion
No community discussion yet for this question.