Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

E. Pollack, J. StrateExpert Performance Indexing in Azure SQL and SQL Server 2022https://doi.org/10.1007/978-1-4842-9215-0_14

14. Query Strategies

Edward Pollack¹   and Jason Strate²

(1)

Albany, NY, USA

(2)

Hugo, MN, USA

 

In the previous chapter, strategies were discussed to identify potential indexes for a wide variety of tables. That is often only half of the story, though. Once indexes have been created, performance is expected to improve within a database, leading then to the next bottleneck. Unfortunately, coding practices and selectivity can negatively influence the application of indexes to queries. Sometimes how the database and tables are being accessed ...