Validating a Table Index

Validate an index on an IQ system store (catalog store) table. You cannot validate indexes on tables in the IQ store (main store).

Prerequisites

Database Version	Table Index Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. RESOURCE authority with ALTER permission on the underlying table of the index. You own the underlying table of the index.
SAP Sybase IQ 16.0	Require VALIDATE ANY OBJECT system privilege.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Schema Objects > Tables.
Select Tables or Global Temporary Tables.
Select a table 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 Table Properties view appears.
In the left pane, select Indexes.

Note: Indexes does not appear for Proxy tables as they are not supported.
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.
Click OK.