Installing HiRDB Advanced Partitioning Option enables you to use the following functions:

• Table matrix partitioning
  Table matrix partitioning is a function that performs key range partitioning by using multiple columns as keys. The use of multiple columns as partitioning keys improves the performance of SQL code that is executed in parallel, and the use of multiple keys for searches accelerates processing by narrowing the searched range. In addition, partitioning database storage areas (RDAREAs) into smaller segments also reduces the time it takes to reorganize the database, to make backups, and to recover the database. For details about table matrix partitioning, see 3.3.9 Table matrix partitioning.
  
• Changing the partitioning storage conditions
  Using ALTER TABLE, you can change the partitioning storage conditions of tables that have been row-partitioned by key range partitioning.^* Changing a table's partitioning storage conditions enables you to reuse RDAREAs that contain outdated data and reduces work time. For details about changing partitioning storage conditions, see 3.3.10 Changing the partitioning storage conditions of a table.
  

*

ALTER TABLE can be used to change a table's partitioning storage condition when one of the following partitioning methods was used:

• Boundary value specification
• Storage condition specification (if the equal sign (=) was used as the comparison operator for the storage condition)