SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-146
CREATE INDEX Statement
[ NAME operation-name ]
[ ]
WITH SHARED ACCESS [ REPORT [ TO collector | ON | OFF ] ]
[ ]
[ { COMMIT [WORK] commit-options } ]
[ { ROLLBACK [WORK] } ]
specifies that the table being indexed be available for read and write access by
DML statements and read access by utilities throughout most of the create index
operation.
The optional clauses allow you to name the operation, control EMS reporting for
the operation, specify a time window for the beginning of the commit phase of the
operation (the phase in which DML and utilities operations on the table are
temporarily restricted), and specify the timeout period for lock requests and the
handling of retryable errors during the commit phase of the operation.
You can use WITH SHARED ACCESS only if the table being indexed is audited
and if each partition of the table resides on a node running version 315 or later of
NonStop SQL/MP. You cannot use WITH SHARED ACCESS on a CREATE INDEX
statement that executes within a user-defined transaction.
For information about operations that use WITH SHARED ACCESS, see WITH
SHARED ACCESS OPTION on page W-4. For information about the optional
clauses, see NAME Option on page N-2, REPORT Option on page R-3, or
COMMIT Option on page C-52.
attribute-spec
specifies file attributes for the key-sequenced file that holds the index. This is a
summary of the file attributes you can specify:
Attribute Action
ALLOCATE Controls amount of disk space allocated. Default is to allocate
space as needed.
AUDITCOMPRESS Controls whether unchanged columns are included in audit
records. Default is to include only changed columns.
BLOCKSIZE Sets size of data blocks. Default is 4096.
BUFFERED* Turns buffering on or off.
CLEARONPURGE* Controls disk erasure when file is dropped.
DCOMPRESS* Controls key compression in data blocks.
DSLACK Sets percent of slack in data blocks. Default is value of the
SLACK attribute.
EXTENT Sets extent sizes. Default is 16 pages for the first extent, 64 for
others.
FORMAT* Sets format for primary partition of the index. Only valid on a
node running version 350 or later.