NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-15
ALTER INDEX Statement
security-spec
sets the following security-related file attributes for index name:
For more detail, see the entry for a specific attribute.
attribute-spec
sets the following file attributes for index name:
For more detail, see the entry for a specific attribute.
DROP PARTITION part-name
specifies the name (or an equivalent DEFINE) of an empty partition to drop from an
index. part-name cannot be the primary partition. You cannot drop a partition
that contains data. If you want to drop a partition that contains data, use the
PARTONLY option of PURGEDATA. See PURGEDATA Command on page P-36
for a discussion of index issues.
CLEARONPURGE Controls disk erasure when index is dropped
NOPURGEUNTIL Sets date after which drop is allowed
SECURE Sets Guardian security string
ALLOCATE Controls amount of disk space allocated
AUDITCOMPRESS Controls whether unchanged columns are included in audit
records
BUFFERED Turns buffering on or off
LOCKLENGTH Sets number of leading bytes in the key to use for generic locks.
Default is 0, which specifies the entire key
MAXEXTENTS Sets maximum extents
RESETBROKEN Resets BROKEN flag
SERIALWRITES Specifies serial or parallel writes
TABLECODE Sets tablecode
VERIFIEDWRITES Controls verification of writes to disk