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 SELECTDBMS_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.reportwcol_usage(‘SH’, ‘customers’) from dual statement.
Identify the correct sequence of steps.
A.
3, 2, 1, 4
B.
2, 3, 4, 1
C.
4, 1, 3, 2
D.
3, 2, 4, 1
Explanation:
B
B