12.3.4 Effects of table row partitioning

The effects obtained when a table is row-partitioned are discussed below.

Organization of this subsection
(1) HiRDB/Single Server
(2) HiRDB/Parallel Server

(1) HiRDB/Single Server

Improved operability
Data storage in table, table reorganization, making backups, and additional operations are available for each user RDAREA.
Key range partitioning
The user RDAREAs that contain particular table data can be determined by searching the SQL_DIV_TABLE dictionary table. This means that if an error occurs in a user RDAREA, the unavailable data can be identified. For details about dictionary table retrieval and the SQL_DIV_TABLE table, see the HiRDB Version 9 UAP Development Guide.

(2) HiRDB/Parallel Server

Improved performance
High-speed table access processing can be achieved, because table access processing can be handled in parallel over multiple user RDAREAs.
Workload of table access processing can be distributed to multiple back-end servers.
Improved operability
Same as for a HiRDB/Single Server.