Throughout this book, we’ve discussed what indexes are, what they do, patterns for building them, and many other aspects for determining how a SQL Server database should be indexed. All of that information is necessary for the last piece in indexing your databases, which is the process of actually applying indexes. To do this, you need a process for applying that knowledge to determine the indexes that are best for your environment and provide the greatest gain to performance.
In this chapter, we’ll discuss a general practice that can be used to build an indexing methodology. We’ll look at the steps necessary to manage ...