Example - PARTITION BY HASH v13
The following example creates a partitioned table (sales)
using the PARTITION BY HASH
clause. The sales
table stores information in three partitions (p1, p2
, and p3
).
The table will return an empty string for the hash partition value specified in the part_no
column.
Use the following command to view the hash value of the part_no
column.
The table is partitioned by the hash value of the values specified in the part_no
column.
The server will evaluate the hash value of the part_no
column and distribute the rows into approximately equal partitions.