Table and Index Architecture

Objects in the SQL Server 2005 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

Topic	Description
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.

See Also

Other Resources

Physical Database Architecture

Help and Information

Getting SQL Server 2005 Assistance