NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-14
ALTER INDEX Statement
name
is the name of an index or 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 ServerWare SMF, only the virtual name changes; the
physical name on the physical volume is preserved.
move-spec is:
{| CATALOG catalog-name |}
{| PHYSVOL volume-name |}
{| EXTENT { size1 | ( size1 [, size2 ] ) } |}
{| MAXEXTENTS int |}
{| DSLACK percent |}
{| ISLACK percent |}
{| SLACK percent |}
wsa-spec is:
{| NAME operation-name |}
{| |}
{| REPORT [ TO collector | ON | OFF ] |}
{| |}
{| { COMMIT [ WORK ] [commit-options] } |}
{| { ROLLBACK [ WORK ] } |}
add-spec is:
{| FIRST KEY { val | ( val [,val ] ... ) } |}
{| WITH DATA MOVEMENT |}
{| CATALOG catalog-name |}
{| PHYSVOL volume-name |}
{| EXTENT { size1 | ( size1 [, size2 ] ) } |}
{| MAXEXTENTS int ] |}