Designing Partitioned Tables and Indexes
The topics in this section provide the information to help you design effective partitioned tables and indexes.
Explains the role that partition functions and partition schemes play in implementing partitioning, and includes examples.
Explains how to use partitioning to move subsets of data between tables in the database, and includes examples.
Explains how to use partitioning to improve query performance, and includes examples.
Provides guidelines on when to partition an index.