NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-134
CREATE INDEX Statement
UNIQUE
specifies that values in the column or set of columns that make up the index field
cannot be the same for two or more rows of the table. For indexes with multiple
columns, the value of the columns as a group determines uniqueness, not the values
of the individual columns.
SQL cannot create a UNIQUE index if any col specified for the index is a column
that allows null values or if the underlying table has duplicate row values for the
group of indexed columns.
index
is a Guardian name (or an equivalent DEFINE) for the new index. The fully
expanded index name must be unique in the network. If the index is partitioned,
index identifies the primary partition.
If ServerWare SMF is installed on your node, the volume portion of index can be
either a direct or virtual volume. If you specify only a subvolume and index name,
SQL creates an index in the current default volume. If the default volume is virtual,
the index resides on the virtual volume. If the default volume is direct, the index
resides on the physical volume as a direct file not managed by ServerWare SMF.
collate-spec is:
COLLATE { collation | CHARACTER SET }
wsa-spec is:
{| NAME operation-name |}
{| REPORT [ TO collector | ON | OFF ] |}
{| { COMMIT [ WORK ] commit-options } |}
{| { ROLLBACK [ WORK ] } |}
attribute-spec is:
{| ALLOCATE integer |}
{| { AUDITCOMPRESS | NO AUDITCOMPRESS } |}
{| BLOCKSIZE integer |}
{| { BUFFERED | NO BUFFERED } |}
{| { CLEARONPURGE | NO CLEARONPURGE } |}
{| { DCOMPRESS | NO DCOMPRESS } |}
{| DSLACK percent |}
{| EXTENT { size | (pri-size [,sec-size]) } |}
{| { ICOMPRESS | NO ICOMPRESS } |}
{| ISLACK percent |}
{| LOCKLENGTH integer |}
{| MAXEXTENTS integer |} {| NOPURGEUNTIL date |}
{| { SERIALWRITES | NO SERIALWRITES } |}
{| SLACK percent |} {| TABLECODE integer |}
{| { VERIFIEDWRITES | NO VERIFIEDWRITES } |}