SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-7
ALTER INDEX Statement
ALTER INDEX Statement
Considerations for ALTER INDEX
Examples of ALTER INDEX
The ALTER INDEX statement modifies an SQL/MX index by changing one or more file
attributes of the index. See Database Object Names on page 6-12.
ALTER INDEX is an SQL/MX extension.
Syntax Description of ALTER INDEX
index
is the ANSI logical name of the index to alter, of the form:
[[catalog-name.]schema-name.]index
where each part of the name is a valid SQL identifier with a maximum of 128
characters. For more information, see Identifiers on page 6-52 and Database
Object Names on page 6-12.
ATTRIBUTE[S] attribute [,attribute ]...
changes the values of file attributes for the index:
In an ATTRIBUTES clause within a PARTITION clause, you must separate
attributes with a space. In ATTRIBUTES clauses in other places, you can
separate attributes with either a space or a comma.
For more detail, see the entry for a specific attribute.
ALTER INDEX [[catalog-name.]schema-name.]index ATTRIBUTE[S]
attribute [,attribute ]...
attribute is:
{ALLOCATE num-extents | DEALLOCATE}
{AUDITCOMPRESS | NO AUDITCOMPRESS}
| {CLEARONPURGE | NO CLEARONPURGE}
| MAXEXTENTS num-extents
ALLOCATE/DEALLOCATE
on page 8-2
Controls amount of disk space allocated.
AUDITCOMPRESS
on
page 8-3
Controls whether unchanged columns occur in
audit records.
CLEARONPURGE on
page 8-5
Controls disk erasure when index is dropped.
MAXEXTENTS on
page 8-7
Controls maximum disk space to be allocated.