Deleting a Materialized View Index

Unused indexes take up space in your database. Delete a materialized view index if you do not require it.

Prerequisites
Database Version Materialized View Index Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • RESOURCE authority with ALTER permission on the underlying database object of the index.
  • You own the underlying database object of the index.
SAP Sybase IQ 16.0 Requires one of:
  • DROP ANY INDEX system privilege.
  • DROP ANY OBJECT system privilege.
  • You own the materialized index.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane, select IQ Servers > Schema Objects > Views > Materialized Views.
  3. Select a materialized view from the right pane and either:
    • Click the arrow to the right of the name and select Properties, or
    • From the Administration Console menu bar, select Resource > Properties.
    The Materialized View Properties view appears.
  4. In the left pane, select Indexes.
  5. Select one or more indexes from the right pane.
    Note: Use Shift-click or Control-click to select multiple indexes.
  6. Click Delete.
    Warning!  There is no confirmation prompt before the indexes are deleted
    .
  7. Do one of the following:
    • Click Apply to upload any property changes to the database and remain in the properties view.
    • Click OK to upload any property changes to the database and exit the properties view.
    • Click Cancel to cancel any unsaved property changes and exit the properties view.
Parent topic: Materialized View Indexes