Statistics Update Procedures Quiz

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

Quiz covering Database Maintenance

What you'll be asked

  1. What is the primary purpose of updating database statistics?
  2. When should you consider performing a manual statistics update instead of relying on auto-update settings?
  3. What is the potential performance impact of using the 'FULLSCAN' option when updating statistics on a massive table?
  4. If a query is running slowly due to 'parameter sniffing', how might updating statistics affect the situation?
  5. In a scenario where you have a table with 100 million rows and a 'skewed' data distribution (e.g., 90% of rows have the same value), why might a default sampling rate result in poor query performance?

Answers and explanations come after you submit.