O'Reilly logo

Expert Performance Indexing in SQL Server, Second Edition by Grant Fritchey, Jason Strate

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 2

image

Index Storage Fundamentals

Where the previous chapter discussed the logical designs of indexes, this chapter will dig deeper into 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 comprises a data page and what can be ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required