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_1

1. Index Fundamentals

Edward Pollack¹   and Jason Strate²

(1)

Albany, NY, USA

(2)

Hugo, MN, USA

 

The goal of this book is to help improve SQL database performance through the use of indexes. To accomplish this, the purpose and use of indexes will be introduced. This will lead to a discussion of how data is stored in indexes, focusing on clustered, non-clustered, and columnstore indexes. We will also explore heaps. Indexing is a key component in any database, whether it is stored on premises or in Azure (or another cloud service).

This chapter ...