SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-13
ALTER INDEX Statement
ALTER INDEX Statement
ALTER INDEX is a DDL statement that renames, changes security, or changes file
attributes for an entire index; drops or adds an index partition; or changes file attributes
for an index partition.
The ALTER INDEX statement also supports several types of move and split
operations, including:

Moving an entire index partition to another disk volume

Merging an index partition into another existing partition

Splitting an index partition and moving a part into a newly created partition

Moving part of an index partition into another existing partition
ALTER INDEX name
{ RENAME new-name }
{ }
{ {| security-spec |} }
{ {| attribute-spec |} }
{ }
{ DROP PARTITION part-name }
{ }
{ {[FROM KEY val [UP TO LAST KEY]] } }
{ { TO dest-part [ move-spec ] } }
{ { [WITH SHARED ACCESS [wsa-spec]] } }
{ { } }
{ {TO dest-part [ move-spec ] } }
{ { WITH SHARED ACCESS [wsa-spec] } }
{ [PARTONLY] MOVE{ } }
{ {([FROM FIRST KEY] UP TO KEY val } }
{ { TO dest-part [ move-spec ], } }
{ { [WITH SHARED ACCESS[wsa-spec]]) } }
{ { } }
{ {([FROM FIRST KEY] UP TO KEY val } }
{ { TO dest-part [ move-spec ], } }
{ { FROM KEY val [UP TO LAST KEY] } }
{ { TO dest-part [ move-spec ]) } }
{ }
{ {| { ALLOCATE int | DEALLOCATE } |} }
{ [PARTONLY] {| MAXEXTENTS int |} }
{ {| RESETBROKEN |} }
{ {| RECOVER INCOMPLETE SQLDDL OPERATION |} }
{ }
{ ADD PARTITION new-part add-spec }