Partitioning Types

SAP ASE supports range partitioning, hash partitioning, list partitioning, and round-robin partitioning.

• Range Partitioning
  Rows in a range-partitioned table or index are distributed among partitions according to values in the partitioning key columns.
• Hash Partitioning
  In hash partitioning, SAP ASE uses a hash function to specify the partition assignment for each row. You select the partitioning key columns, but SAP ASE chooses the hash function that controls the partition assignment.
• List Partitioning
  As with range partitioning, list partitioning distributes rows semantically; that is, according to the actual value in the partitioning key column.
• Round-Robin Partitioning
  In round-robin partitioning, SAP ASE assigns rows in a round-robin manner to each partition so that each partition contains a more or less equal number of rows and load balancing is achieved. Because there is no partition key, rows are distributed randomly across all partitions.