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.

In This Section



Understanding Partitioning

Provides an overview of partitioning and how it can be used in the AdventureWorks2008R2 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.