NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-13
ALTER INDEX Statement
•
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 }
security-spec is:
{| { CLEARONPURGE | NO CLEARONPURGE } |}
{| NOPURGEUNTIL date |}
{| SECURE "rwep" |}
attribute-spec is:
{| { ALLOCATE int | DEALLOCATE } |}
{| { AUDITCOMPRESS | NO AUDITCOMPRESS } |}
{| { BUFFERED | NO BUFFERED } |}
{| LOCKLENGTH int |}
{| MAXEXTENTS int |}
{| RESETBROKEN |}
{| { SERIALWRITES | NO SERIALWRITES } |}
{| TABLECODE int |}
{| { VERIFIEDWRITES | NO VERIFIEDWRITES } |}