SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-142
CREATE INDEX Statement
CREATE INDEX Statement
CREATE INDEX is a DDL statement that creates an index based on one or more
columns of a table.
CREATE [ UNIQUE ] INDEX index ON table
( col [ ASC[ENDING] ] [ collate-spec ]
[ DESC[ENDING] ]
[ , col [ ASC[ENDING] ] [ collate-spec ] ] ... )
[ DESC[ENDING] ]
[| CATALOG catalog |]
[| PHYSVOL volume-name |]
[| { INVALIDATE | NO INVALIDATE } |]
[| KEYTAG key-specifier |]
[| PARALLEL EXECUTION { ON [ CONFIG file ] | OFF } |]
[| PARTITION ( partition [ , partition ] ... ) |]
[| WITH SHARED ACCESS [ wsa-spec ] |]
[| attribute-spec |]
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]) } |}
{| { FORMAT 1 | FORMAT 2 } |}
{| { ICOMPRESS | NO ICOMPRESS } |}
{| ISLACK percent |}
{| LOCKLENGTH integer |}
{| MAXEXTENTS integer |} {| NOPURGEUNTIL date |}
{| { SERIALWRITES | NO SERIALWRITES } |}
{| SLACK percent |} {| TABLECODE integer |}
{| { VERIFIEDWRITES | NO VERIFIEDWRITES } |}