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 |
|---|---|
Describes the organization of table and index pages. |
|
Explains how data rows are stored in a heap and how they are accessed and maintained. |
|
Explains how data rows are stored in a clustered index and how they are accessed and maintained. |
|
Explains how index rows are stored in a nonclustered index and how they are accessed and maintained. |
See Also
Other Resources
Physical Database Architecture