CHAPTER 4
Much Ado About Indexes
The keys to a healthy SQL Server are healthy indexes, and therefore I’ll cover indexes in this chapter. This chapter is an introduction to indexes and does not deep dive into index internals. Instead, the goal of this chapter is to provide you with some useful index analysis scripts and methods so you can understand how indexes affect the performance of your SQL Server. The primary things you need to look at in terms of having a healthy index strategy and therefore a high-performing SQL Server are as follows: missing indexes, too many indexes, duplicate indexes, and fragmented indexes. You’ll look at index usage ...
Get Healthy SQL : A Comprehensive Guide to Healthy SQL Server Performance 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.
