Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Partitioned Tables and Indexes

The data in partitioned tables and indexes is horizontally divided into units that can be spread across more than one filegroup in a database. Partitioning can make large tables and indexes more manageable and scalable.

Partitioned tables and indexes are available only on the Enterprise, Developer, and Evaluation editions of SQL Server.

This section provides the information that is required to understand, design, implement, and work with partitioned tables and indexes.



Understanding Partitioning

Provides an overview of partitioning and how it can be used in the AdventureWorks sample database.

Designing Partitioned Tables and Indexes

Explains the factors to consider when planning a partitioning scenario in your database, and includes examples.

Implementing Partitioned Tables and Indexes

Provides guidelines, rules, and restrictions for creating and modifying partitioned tables and indexes.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft