Table Partitions

Table partitioning can improve performance by dividing large tables into smaller, more manageable storage objects. Partitions share the same logical attributes of the parent table, but can be placed in separate dbspaces and managed individually.

• Restrictions
  Some restrictions apply to table partitions.
• Range Partitions
  Range partitioning divides large tables by a range of partition-key values established for each partition.
• Hash Partitions
  Hash partitioning maps data to partitions based on partition-key values processed by an internal hashing function.
• Hash-Range Partitions
  Hash-range partitioning is a composite partitioning scheme that subpartitions a hash-partitioned table by range.