SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-15
ALTER INDEX Statement
name
is the name of an index or an index partition to alter or move (or an equivalent
DEFINE). If name is a partition and you use clauses that apply to an entire index,
SQL interprets name as identifying all partitions of the index.
RENAME new-name
changes the file and subvolume portions of the name of an index (including all
partitions) to those in the Guardian name (or equivalent DEFINE) new-name,
updating all catalog references to the index to reflect the change.
name and new-name must have the same node and volume name when
expanded. If the index is managed by SMF, only the virtual name changes; the
physical name on the physical volume is preserved.
security-spec
sets these security-related file attributes for index name:
For more information, see the entry for a specific attribute.
attribute-spec
sets these file attributes for index name:
For more information, 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
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