2 out of 3 rated this helpful - Rate this topic

Designing Partitioned Tables and Indexes

SQL Server 2008 R2

The topics in this section provide the information to help you design effective partitioned tables and indexes.

Topic	Description
Planning Guidelines for Partitioned Tables and Indexes	Explains the role that partition functions and partition schemes play in implementing partitioning, and includes examples.
Designing Partitions to Manage Subsets of Data	Explains how to use partitioning to move subsets of data between tables in the database, and includes examples.
Designing Partitions to Improve Query Performance	Explains how to use partitioning to improve query performance, and includes examples.
Special Guidelines for Partitioned Indexes	Provides guidelines on when to partition an index.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions