SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-54
CREATE INDEX Statement
CREATE INDEX Statement
Considerations for CREATE INDEX
Examples of CREATE INDEX
The CREATE INDEX statement creates an SQL/MX index based on one or more
columns of a table. See Database Object Names on page 6-12.
CREATE INDEX is an SQL/MX extension.
CREATE [UNIQUE] INDEX index ON table
(column-name [ASC[ENDING] | DESC[ENDING]]
[,column-name [ASC[ENDING] | DESC[ENDING]]]...)
[populate-option]
[file-option]...
populate-option is: POPULATE | NO POPULATE
file-option is:
LOCATION [\node.]$volume[.subvolume.file-name]
[NAME partition-name]
| partn-file-option
| ATTRIBUTE[S] attribute [,attribute]...
partn-file-option is
{[RANGE] PARTITION
[BY (partitioning-column [,partitioning-column]...)]
[(ADD range-partn-defn [,ADD range-partn-defn]...)]
| HASH PARTITION
[BY (partitioning-column [,partitioning-column]...)]
[(ADD partn-defn [,ADD partn-defn]...)]}
range-partn-defn is:
FIRST KEY {col-value | (col-value [,col-value]...)}
partn-defn
partn-defn is:
LOCATION [\node.]$volume[.subvolume.file-name]
[EXTENT ext-size | (pri-ext-size [,sec-ext-size])]
[MAXEXTENTS num-extents
[NAME partition-name] [attribute [,attribute]...]
attribute is:
ALLOCATE num-extents
| {AUDITCOMPRESS | NO AUDITCOMPRESS}
| BLOCKSIZE number-bytes
| {CLEARONPURGE | NO CLEARONPURGE}
| EXTENT ext-size | (pri-ext-size [,sec-ext-size])
| MAXEXTENTS num-extents