Abstract
In the last chapter, you looked at strategies to identify potential indexes for your databases. That, though, is often only half of the story. Once the indexes have been created, you would expect performance within the database to improve, leading you then to the next bottleneck. Unfortunately, coding practices and selectivity can sometimes negatively influence the application of indexes to queries. And sometimes how the database and tables are being accessed will prevent the use of some of the most beneficial indexes in your databases.
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). Query Strategies. In: Expert Performance Indexing for SQL Server 2012. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3742-6_9
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3742-6_9
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