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.
To get to this understanding, the chapter will start with some of the basics about data storage. First, you’ll look at data pages and how they are laid out. This examination will detail what ...
