You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply