SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—523725-004

2-8

Considerations for ALTER INDEX

You cannot use ALTER INDEX to change a partition’s name.

Authorization and Availability Requirements

To alter an index, you must own its schema or be the super ID.

All partitions of the index must be available when ALTER INDEX executes. The

appropriate metadata tables must also be available.

Examples of ALTER INDEX

•

This example changes the maximum number of extents to 760:

ALTER INDEX xempname ATTRIBUTE MAXEXTENTS 760