Why Won't PostgreSQL Use My Covering Index?
Dear Postgres, Why won’t you use my covering index?
Lately I’ve been learning to tune queries running against PostgreSQL, and it’s …
Read MoreManaging Statistics in SQL Server for DBAs (videos)
on • 1 min read
Category:
query-performance
, database-administration
Want to learn more about managing statistics updates in SQL Server? Watch my 27 minute presentation on managing statistics.
Main Presentation
Q&A Session
You can also watch 12 minutes of audience Q&A on statistics from when I presented this on a live Hangout on Air. Questions include:
- Should I create single column statistics for non-leading key columns in an index?
- What is asynchronous statistics update?
- What are these statistics with “WA_sys” names?
- I have a bunch of user created statistics and it’s blocking a release. It is safe to drop them?
More Resources
Got more questions on statistics? Check out my reference post on Updating Statistics in SQL Server, and ask away in the comments of the post!
RELATED POSTS
