Abstract
Indexing databases is often thought of as an art where the database is the canvas and the indexes are the paints that come together to form a beautiful tapestry of storage and performance. A little color here, a little color there, and paintings will take shape. In much the same way, a clustered index on a table and then a few nonclustered indexes can result in screaming performance as beautiful as any masterpiece. Going a little too abstract or minimalist with your indexing might make you feel good, but the performance will let you know it isn’t too useful.
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
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2015 Jason Strate and Grant Fritchey
About this chapter
Cite this chapter
Strate, J., Fritchey, G. (2015). Indexing Strategies. In: Expert Performance Indexing in SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1118-2_11
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1118-2_11
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1119-9
Online ISBN: 978-1-4842-1118-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books