Abstract
By now, you should have a good understanding of the importance of indexes. It is even more important for the optimizer to have the necessary information on the data distribution so that it can choose indexes effectively. In SQL Server, this information is maintained in the form of statistics on the index key.
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 Grant Fritchey
About this chapter
Cite this chapter
Fritchey, G. (2012). Statistics Analysis. In: SQL Server 2012 Query Performance Tuning. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4204-8_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4204-8_7
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4203-1
Online ISBN: 978-1-4302-4204-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books