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_17

17. Indexing Methodology

Edward Pollack¹   and Jason Strate²

(1)

Albany, NY, USA

(2)

Hugo, MN, USA

 

Throughout this book, we’ve discussed what indexes are, what they do, patterns for building them, and many other aspects for determining how a SQL Server database should be indexed. All that information is necessary for the last puzzle piece in database indexing, which is a methodology for managing indexes. To do this, a process is needed for applying that knowledge to determine the indexes that are best for an environment and provide the ...