NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-137
CREATE INDEX Statement
the =_SORT_DEFAULTS DEFINE. See the FastSort Manual for further
information on configuring subsorts. See Examples—CREATE INDEX on
page C-140.
PARTITION ( partition [ , partition ] ... )
defines secondary partitions for a partitioned index.
partition is the definition of a single secondary partition and includes the
location of the partition, the first key value for the partition, and (optionally) the
catalog, physical volume, and EXTENT and MAXEXTENT values for the partition.
See PARTITION Clause
on page P-16 for details of this clause.
[ 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.
See WITH SHARED ACCESS OPTION
on page W-4 for detailed information
about operations that use WITH SHARED ACCESS. See NAME Option
on
page N-2, REPORT Option
on page R-3, or COMMIT Option on page C-46 for
detailed information about the optional clauses.
attribute-spec
specifies file attributes for the key-sequenced file that holds the index. Following is
a summary of the file attributes you can specify:
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.