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
Topic |
Description |
|---|---|
Provides an overview of partitioning and how it can be used in the AdventureWorks2008R2 sample database. |
|
Explains the factors to consider when planning a partitioning scenario in your database, and includes examples. |
|
Provides guidelines, rules, and restrictions for creating and modifying partitioned tables and indexes. |