SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Clauses
HP NonStop SQL/MX Reference Manual—540440-003
7-24
Effect of Storage Order on Partitioning
This ordering mechanism is the only method that allows you to partition by values of a
nonunique key.
You cannot specify a STORE BY key-column-list and a NOT DROPPABLE PRIMARY
KEY in the same statement.
The relationship between the STORE BY clause, the primary key, and the clustering
key in addition to the resulting default partitioning key is summarized in Table 6-1,
Construction of the Clustering Key, on page 6-56 and Table 6-2, Clustering Key for
Indexes, on page 6-57.
Effect of Storage Order on Partitioning
Primary Key Storage Order
If your clustering key is based on a non droppable primary key, you can partition the
table. This ordering mechanism is generally the most efficient method if you want to
partition by values of a unique key.
SYSKEY Storage Order
You cannot partition a table stored only by the SYSKEY.
Key Column List Storage Order
If you specify STORE BY key-column-list, you can partition based on values of the
columns in key-column-list.
You must use this storage order to partition by values of a nonunique key.