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 |
You must have 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 |
You must have the VALIDATE ANY OBJECT
system privilege. |
-
The SAP Sybase IQ resource is authenticated and
running.
-
In a multiplex
configuration, the coordinator node is running.
-
The table is an IQ system store (catalog store) table.
Task- In the Perspective Resources view, select the resource, and
select .
- In the left pane, expand , and then 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 .
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.
- 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:
- Click OK to update any changes to the
database and exit the properties view.
- Click Apply to update any changes to the database, but
remain in the properties view.
- Click Cancel to cancel any changes not
updated to the database and exit the properties view.