Statistics Management Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Query Optimization

What you'll be asked

  1. What is the primary purpose of database statistics in the context of query optimization?
  2. Which of the following scenarios most strongly suggests that statistics on a table are stale and need to be updated?
  3. If an execution plan shows a massive discrepancy between 'Estimated Rows' and 'Actual Rows', what is the most likely root cause?
  4. Why might an optimizer choose a Nested Loop join instead of a Hash Join even when statistics are up to date?
  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?

Answers and explanations come after you submit.