Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Designing Partitioned Tables and Indexes

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?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.