Healthy SQL pp 81-114 | Cite as

Much Ado About Indexes

  • Robert Pearl


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 statistics and how queries are affected, and I’ll discuss page splitting and fill factor. These are some of the highlights of this chapter:


Fill Factor Execution Plan Query Optimizer Query Execution Query Performance 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Robert Pearl 2015

Authors and Affiliations

  • Robert Pearl
    • 1
  1. 1.NYUS

Personalised recommendations