3 Partitioning for Availability, Manageability, and Performance

Partitioning enables availability, manageability, and performance.

This chapter provides high-level insight into how partitioning enables availability, manageability, and performance. Guidelines are provided on when to use a given partitioning strategy. The main focus is the use of table partitioning, although most of the recommendations and considerations apply to index partitioning as well.

This chapter contains the following sections:

• Partition Pruning

• Partition-Wise Operations

• Index Partitioning

• Partitioning and Table Compression

• Recommendations for Choosing a Partitioning Strategy