Abstract
Recent versions of SQL Server support many different types of index that are used to enhance query performance. These include traditional clustered and nonclustered indexes, which are built on B-tree (balanced-tree) structures and enhance read performance on disk-based tables. There are also indexes that support complex data types, such as XML, JSON, and geospatial data types. These advanced data type indexes are beyond the scope of this book, but a full discussion can be found in the Apress title SQL Server Advanced Data Types, which can be found at www.apress.com/gp/book/9781484239001. DBAs can also create Columnstore indexes to support data warehouse–style queries, where analysis is performed on very large tables. SQL Server also supports in-memory indexes, which enhance the performance of tables that are stored using In-Memory OLTP. This chapter discusses many of the available index types inside the Database Engine.
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
© 2023 The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature
About this chapter
Cite this chapter
Carter, P.A. (2023). Indexes and Statistics. In: Pro SQL Server 2022 Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-8864-1_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-8864-1_8
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-8863-4
Online ISBN: 978-1-4842-8864-1
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)