You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers
Posted: Sun Jun 11, 2023 3:51 pm
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
A. 3, 2, 1, 4
B. 2, 3, 4, 1
C. 4, 1, 3, 2
D. 3, 2, 4, 1