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 AdventureWorks sample database.

In This Section

Topic Description

Partitioned Table and Index Concepts

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

Partitioning in the AdventureWorks Sample Database

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