Rebuilding a Materialized View Index

As data is modified in the underlying tables that the indexes operate on, the indexes become fragmented. Rebuild fragmented indexes on materialized views to improve performance.

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: ALTER ANY INDEX system privilege. ALTER ANY OBJECT system privilege. You own the underlying database object of the index.

The SAP Sybase IQ resource is authenticated and running.
In a multiplex configuration, the coordinator node is running.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Schema Objects > Views > Materialized Views.
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.
In the left pane, select Indexes.
Select one or more indexes from the right pane and click Rebuild.

Note: Use Shift-click or Control-click to select multiple indexes.

The Rebuild Indexes view appears when complete and indicates the rebuild status of each selected index.
Click OK.