Abstract
Where the previous chapter discussed the logical design and syntax of indexes, this chapter will focus on the physical implementation of indexes. An understanding of the way in which indexes are laid out and interact with each other at the implementation and storage level will help you become better acquainted with the benefits that indexes provide and why they behave in certain ways.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
“Columnstore Indexes: A New Feature in SQL Server known as Project ‘Apollo,’ ” Microsoft SQL Server Team Blog, http://blogs.technet.com/b/dataplatforminsider/archive/2011/08/04/columnstore-indexes-a-new-feature-in-sql-server-known-as-project-apollo.aspx
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Jason Strate
About this chapter
Cite this chapter
Strate, J. (2019). Index Storage Fundamentals. In: Expert Performance Indexing in SQL Server 2019. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5464-6_2
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5464-6_2
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)