Chapter 11. Tuning index designs
By now, you should understand how indexes work, and how to maintain them. But what do you do if some of your indexes are no longer hitting the perfect balance of positive and negative performance impact? It may be time to tune those things!
We’re about to embark on something that is traditionally collaboration between developers and DBAs, and we’ll potentially be modifying portions of the overall database design (specifically, the index structure). Please follow along carefully, and be sure to follow the cautions and tips that I’ll offer.
11.1. How indexes can become less useful
The indexes that a developer or DBA creates on a database are often put there as a best guess about what will provide the most balanced ...
Get Learn SQL Server Administration in a Month of Lunches now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
