Indexing

  • Benjamin Nevarez
Chapter

Abstract

Indexing is, without a doubt, the best way 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 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.

Keywords

Range Query Execution Plan Query Optimizer Query Processor Trivial Plan 
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

© Benjamin Nevarez 2016

Authors and Affiliations

  • Benjamin Nevarez
    • 1
  1. 1.Santa ClaritaUSA

Personalised recommendations