SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-16
ALTER INDEX Statement
contains data. If you want to drop a partition that contains data, use the
PARTONLY option of the PURGEDATA command. For more information on index
issues, see PURGEDATA Command on page P-36.
{[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 ]) } }
moves a specified portion of the index name to a new or existing partition,
dest-part, that has the attributes described in move-spec. You can specify
dest-part with a Guardian name, a DEFINE equivalent to a Guardian name, a
node name and a volume name, or a volume name only.
For more information about move operations, see the discussion of performing
moves under Considerations—ALTER INDEX on page A-19.
PARTONLY indicates that name is a partitioned index, one partition of which is to
be moved or split. You must include PARTONLY if name is partitioned.
val is a list of comma-separated literals (one for each column in the key) that
specifies a point to split the existing partition. Use the keyword NULL to represent
a null value in the list.
move-spec
sets the catalog name and these file attributes for the index or partition dest-
part:
CATALOG Sets the catalog name
PHYSVOL Sets a physical volume for the new partition that overrides SMF
EXTENT Sets extent sizes
MAXEXTENTS Sets maximum extents
FORMAT Sets format. Only valid on a node running version 350 or later.
DSLACK Sets percent of slack in data blocks
ISLACK Sets percent of slack in index blocks
SLACK Sets percent of slack in blocks if not specified by DSLACK or
ISLACK