High Performance SQL Server: Consistent Response for Mission-Critical Applications

© Benjamin Nevarez 2021

B. NevarezHigh Performance SQL Serverhttps://doi.org/10.1007/978-1-4842-6491-1_9

9. Indexing

Benjamin Nevarez¹  

(1)

Santa Clarita, CA, USA

 

Indexing is, without a doubt, one of the best ways to improve the performance of your queries and applications, and this book would not be complete without covering this topic. This chapter explains how indexes work, how you can define the right indexes for your application, and how you can use some of the tools available in SQL Server to help you make the best possible decisions about your indexes. These tools include the missing indexes feature and the Database Engine Tuning Advisor, also called the DTA.

This chapter will also show you why the lack of indexes or even poorly designed indexes ...