Abstract
Like anything in life, indexes require maintenance. Over time, the performance benefits of indexes can wane or, through data modifications, their sizes and the underlying statistics can bloat. To prevent these issues, indexes must be maintained. If you do so, your database will remain lean, mean, querying machines.
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 Maintenance. In: Expert Performance Indexing for SQL Server 2012. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3742-6_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3742-6_6
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