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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-55
Syntax Description of CREATE INDEX
partn-file-option is:
{[RANGE] PARTITION
[BY (partitioning-column [,partitioning-column]...)]
[(ADD range-partn-defn [,ADD range-partn-defn]...)]
defines secondary partitions for a range partitioned table. See Partitions on
page 6-79 for details about partitions.
BY (partitioning-column [,partitioning-column]...)
specifies the partitioning columns. The default is the default partitioning key
created by the STORE BY clause. Partitioning character columns must derive
from the ISO88591 character set. Partitioning columns cannot be floating-point
data columns.
| HASH PARTITION
[BY (partitioning-column [,partitioning-column]...)]
[(ADD partn-defn [,ADD partn-defn]...)]}
defines secondary partitions for a hash partitioned table. See Partitions on
page 6-79 for details about partitions.
BY (partitioning-column [,partitioning-column]...)
specifies the columns that make up the partitioning key. If you do not specify
this clause, the partitioning key is the same as the clustering key of the table.
Partitioning columns cannot be floating-point data columns.
ADD range-partn-defn
defines a single secondary partition and includes the FIRST KEY and a
partn-defn.
range-partn-defn is:
FIRST KEY {col-value | (col-value [,col-value]...)} partn-defn
specifies the beginning of the range for a range partitioned table. The
FIRST KEY clause specifies the lowest values in the partition for columns
stored in ascending order and the highest values in the partition for
columns stored in descending order. These column values are referred to
as the partitioning key.
col-value is a literal that specifies the first value allowed in the
associated partition for that column of the partitioning key. If there are more
storage key columns than col-value items, the first key value for each
remaining key column is the lowest or highest value for the data type of the
column (the lowest value for an ascending column and the highest value
for a descending column). col-value must contain characters only from
the ISO88591 character set.