Example 1: Flexible hash partitioning

Nonstop Database, HiRDB Version 9 System Operation Guide

This example changes to HASH6 the hash function of table TABLE01. TABLE01 is flexible hash partitioned.

Organization of this subsection: (1) Use the ALTER TABLE statement to change the hash function

 
ALTER TABLE TABLE01 CHANGE HASH HASH6;