SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-12
Considerations for ALTER INDEX
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.
Considerations for ALTER INDEX
You cannot use ALTER INDEX to change the Guardian name of a partition. To change
the Guardian name of a partition, use the Modify utility with the rename option. For
more information, see Renaming Guardian Location of Partitions of Tables, Indexes or
Sequence Generators.
Authorization and Availability Requirements
To alter an index, you must own the schema or be the super ID or object owner.
All partitions of the index must be available when ALTER INDEX executes. The
appropriate metadata tables must also be available.
Renaming an Index
You can use the rename option to change the name of an index. The following are the
prerequisites for renaming an index:
•
The new ANSI name must not already exist within the schema.
•
All partitions of the index and base table must be available.
Effects on TMF
Rename
For information on effects of rename option on TMF, see Effects on TMF
on page 2-40.
Effects on RDF
Rename
ALLOCATE/DEALLOCATE
on page 9-2
Controls amount of disk space allocated.
AUDITCOMPRESS
on
page 9-3
Controls whether unchanged columns occur in
audit records.
CLEARONPURGE
on
page 9-5
Controls disk erasure when index is dropped.
MAXEXTENTS on
page 9-7
Controls maximum disk space to be allocated.