Tables and Index Data Structures Architecture

Objects in the SQL Server database are stored as a collection of 8-KB pages. This section describes the way the pages for tables and indexes are organized, stored, and accessed. 

In This Section

• Table and Index Organization
  Describes the organization of table and index pages.

• Heap Structures
  Explains how data rows are stored in a heap and how they are accessed and maintained

• Clustered Index Structures
  Explains how data rows are stored in a clustered index and how they are accessed and maintained.

• Nonclustered Index Structures
  Explains how index rows are stored in a nonclustered index and how they are accessed and maintained.