Validating a Materialized View Index

Validate an index on a materialized view.

Prerequisites

Database Version	Materialized View Index Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority VALIDATE authority
SAP Sybase IQ 16.0	You must have the VALIDATE ANY OBJECT system privilege.

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Schema Objects > Views, and then select 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 Validate.

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

Note: Validate does not appear when the underlying table is an IQ store (main store) table.

The Validate Indexes view appears when complete and indicates the validation status of each selected index.
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.