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.

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

In This Section

Topic Description

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.