Why Index Fragmentation and Bad Statistics Aren’t Always the Problem (Video)
Do you rely on index rebuilds to make queries run faster? Or do you always feel like statistics are “bad” and are the cause of your query problems? You’re not alone– it’s easy to fall into the trap of always blaming fragmentation or statistics. Learn why these two tools aren’t the answer to every problem in these two videos from Kendra Little.
Does Rebuilding Indexes Make Queries Faster in SQL Server?
Learn if rebuilding indexes is a good way to help queries run faster in SQL Server in this 13 minute video.
https://www.youtube.com/watch?v=qxQv0576iAU
Not convinced that fragmentation isn’t really your problem? Read Brent’s post, “Stop Worrying about Index Fragmentation“.
Why are Statistics Always the Problem? (Or ARE They?)
Once you’ve moved beyond an addiction to rebuilding indexes, you may find that you become an obsessive Statistics Blamer. Learn why you might mistakenly think your stats are “bad” when something else is really the problem in this 12 minute video.
https://www.youtube.com/watch?v=EYzgZGD2kRE
Want to learn more about statistics, parameter sniffing, and hints? Read “Optimize for… Mediocre?” and “Recompile Hints and Execution Plan Caching“.
1 Comment. Leave new
Great video Kendra! A while back, I too used the golden hammer of index rebuilding, much to the chagrin of my storage replication out to a DR site. Talk about a waste of time and data shuffling! I’d love to see a video on statistics, covering things such as….is auto-update statistics good enough? Should we schedule an automated update for all statistics that haven’t updated frequently, etc…. Keep up the good work and thanks for the great videos you guys constantly produce!