Recommendations for Choosing a Partitioning Strategy

The following sections provide recommendations for choosing a partitioning strategy:

• When to Use Range or Interval Partitioning

• When to Use Hash Partitioning

• When to Use List Partitioning

• When to Use Composite Partitioning

• When to Use Interval Partitioning

• When to Use Reference Partitioning

• When to Partition on Virtual Columns

• Considerations When Using Read-Only Tablespaces