Example: PARTITION BY HASH v16
This 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 returns 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 evaluates the hash value of the part_no
column and distributes the rows into approximately equal partitions.