Abstract
Throughout this book, we’ve discussed what indexes are, what they do, patterns for building them, and many other aspects for determining how a SQL Server database should be indexed. All of that information is necessary for the last piece in indexing your databases, which is the process of actually applying indexes. To do this, you need a process for applying that knowledge to determine the indexes that are best for your environment and provide the greatest gain to 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
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Jason Strate and Ted Krueger
About this chapter
Cite this chapter
Strate, J., Krueger, T. (2012). Index Analysis. In: Expert Performance Indexing for SQL Server 2012. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3742-6_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3742-6_10
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3741-9
Online ISBN: 978-1-4302-3742-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books