Understanding Partitioning

The topics in this section provide the information to help you understand the concepts of partitioned tables and indexes and the reasons for implementing partitioning, and an overview of how partitioned tables and indexes are implemented in the AdventureWorks2008R2 sample database.

In This Section



Partitioned Table and Index Concepts

Explains partitioned tables and indexes, and the benefits of partitioning.

Partitioning in the AdventureWorks2008R2 Sample Database

Explains the partitioning scripts that can be run against the AdventureWorks2008R2 sample database to implement a partitioning design, and the benefits of this design in a real-world scenario.