Abstract
In the previous chapter, we looked at strategies to identify potential indexes for your databases. That, though, is often only half 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
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Jason Strate
About this chapter
Cite this chapter
Strate, J. (2019). Query Strategies. In: Expert Performance Indexing in SQL Server 2019. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5464-6_12
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5464-6_12
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5463-9
Online ISBN: 978-1-4842-5464-6
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)