Abstract
It is impossible to define an indexing strategy that will work everywhere. Every system is unique and requires its own indexing approach based on workload, business requirements, and quite a few other factors. However, there are several design considerations and guidelines that can be applied in every system.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Dmitri Korotkevitch
About this chapter
Cite this chapter
Korotkevitch, D. (2016). Designing and Tuning the Indexes. In: Pro SQL Server Internals. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1964-5_7
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1964-5_7
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1963-8
Online ISBN: 978-1-4842-1964-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books