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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Benjamin Nevarez
About this chapter
Cite this chapter
Nevarez, B. (2016). Indexing. In: High Performance SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-2271-3_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-2271-3_8
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-2270-6
Online ISBN: 978-1-4842-2271-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books