You want to capture column group usage and gather extended statistics for better
cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following
steps: 1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’,
‘CUSTOMERS’) FROM dual statement. 2. Execute the
DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure. 3. Execute the required
queries on the CUSTOMERS table. 4. Issue the SELECT
DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement.
Identify the correct sequence of steps.
A.
3, 2, 4, 1
B.
3, 2, 1, 4
C.
2, 3, 4, 1
D.
4, 1, 3, 2
Correct: 2341
Answer is correct
An example of why: https://oracle-base.com/articles/11g/extended-statistics-enhancements-11gr2
Steps
1. Tell the database to monitor column group usage for a period of time.
2. Execute a statement during the period of examination
3. Report on DB’s findings
4. Create extended stats based on these results
C