Abstract
The goal of this book is to help you improve the performance of your databases through the use of indexes. In order to accomplish this, you must first understand what indexes are and why you need them. You need to understand the differences between how data in a clustered index, columnstore index, and heap table is stored. You also will look at how nonclustered and other index types are built and how indexes interact with other indexes. This chapter will provide the building blocks for understanding the logical design of indexes.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Jason Strate
About this chapter
Cite this chapter
Strate, J. (2019). Index Fundamentals. In: Expert Performance Indexing in SQL Server 2019. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5464-6_1
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5464-6_1
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)