Altering an index

To alter an index:

Procedure

  1. In the navigation tree pane, select a catalog and then expand Schemas folder within it.

    List of schemas appears.

  2. Expand a selected schema and select Tables folder.
  3. Expand the Tables folder.

    List of tables appears.

  4. Select and expand a table within it.

    Indexes and Triggers folders appear.

  5. Expand the Indexes folder.

    List of indexes appears.

  6. Select an index name and then right-click and select Alter Index.

    Alter Index dialog appears with the existing values of the index.

    Alter Index dialog

    The following attributes appear in the Alter Index dialog:

    • Audit Compress— This attribute controls whether unchanged columns are included in audit records.

    • Clear On Purge — This attribute controls the disk cleanup when an index is dropped. If Clear On Purge is selected, then the contents of the index are overwritten when it is purged. Otherwise, NonStop SQL/MX deallocates disk space but does not physically destroy the data in that disk space.

    • Maximum Extents for every partition— This attribute sets the maximum number of extents for all of the partitions. All the index partitions will have this maximum extents value.

    • Allocate/Deallocate for every partition — This attribute allocates the specified number of extents for all partitions if Allocate is selected, or deallocates all extents from all partitions if Deallocate is selected.

  7. Select or clear the required attributes and click OK to alter the selected index.