Abstract
As discussed in Chapter 22, SQL Server query performance tuning and optimization requires a multilayered approach. This chapter focuses on the index and statistics tuning aspects of that approach. The following are a few key factors that impact SQL Server query performance:
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
© 2015 Jason Brimhall, Jonathan Gennick, and Wayne Sheffield
About this chapter
Cite this chapter
Brimhall, J., Gennick, J., Sheffield, W. (2015). Chapter 24: Index Tuning and Statistics. In: SQL Server T-SQL Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0061-2_24
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0061-2_24
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0062-9
Online ISBN: 978-1-4842-0061-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books