SQL/MP Installation and Management Guide

Adding, Altering, Removing, and Renaming
Database Objects
HP NonStop SQL/MP Installation and Management Guide—523353-004
7-19
Altering Index Attributes
For more information about view attributes, see Creating Views of Base Tables on
page 5-38.
Altering Index Attributes
The ALTER INDEX statement can alter several file and security attributes of an index.
For security attributes, you can alter only CLEARONPURGE, NOPURGEUNTIL, or
SECURE. The index owner and security are set and altered by those attributes of the
underlying table. You can independently alter all file attributes of an index except the
AUDIT attribute.
You can alter a single partition of a partitioned index by specifying the PARTONLY
clause in the ALTER INDEX statement.
For a partitioned index, if you omit PARTONLY, the statement operates on all partitions,
and all partitions must be accessible.
For a detailed description of index security dependencies, see the description of the
ALTER INDEX statement in the SQL/MP Reference Manual.
These examples alter attributes of an index:
>> ALTER INDEX $VOL1.PERSNL.XEMPL NO CLEARONPURGE;
--- SQL operation complete.
>> ALTER INDEX $VOL1.SALES.XORDCUS
+> PARTONLY MAXEXTENTS 300;
--- SQL operation complete.
To alter an index, follow these steps:
1. Start an SQLCI session. Enter a LOG command to initiate a log file for the
statements and commands entered in this session. Keep the log for your records.
2. Determine the name of the index you want to alter.
3. Enter the ALTER INDEX statement.
For more information about index attributes, see Creating Indexes on Base Tables
on
page 5-42.
Altering Partition Attributes
You can alter the attributes of a single partition of a partitioned table or index by
specifying the PARTONLY clause in the ALTER TABLE or ALTER INDEX statement.
You can alter the partition attributes MAXEXTENTS, ALLOCATE, and DEALLOCATE.
You cannot alter the security string for a partition.
This example deallocates unused extents of a table partition located on
$VOL1.SALES:
>> ALTER TABLE $VOL1.SALES.ORDERS
+> PARTONLY DEALLOCATE;
--- SQL operation complete.