Partitioning Strategies

Oracle Partitioning offers three fundamental data distribution methods as basic partitioning strategies that control how data is placed into individual partitions:

  • Range

  • Hash

  • List

Using these data distribution methods, a table can either be partitioned as a single-level or as a composite-partitioned table:

Each partitioning strategy has different advantages and design considerations. Thus, each strategy is more appropriate for a particular situation.