Statistics Management Quiz

Quiz covering Query Optimization

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 1

   What is the primary purpose of database statistics in the context of query optimization?

2. 2

   Which of the following scenarios most strongly suggests that statistics on a table are stale and need to be updated?

3. 3

   If an execution plan shows a massive discrepancy between 'Estimated Rows' and 'Actual Rows', what is the most likely root cause?

4. 4

   Why might an optimizer choose a Nested Loop join instead of a Hash Join even when statistics are up to date?

5. 5

   When dealing with skewed data (e.g., a column where 95% of rows have the same value), what feature should be utilized to improve query plan accuracy?