12.3.4 Effects of table row partitioning
(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.