Set a clustered index on a system store (IQ catalog store) table. Using a clustered
index increases the chance that two rows from adjacent index entries will appear on the same
page in the database. This strategy can lead to performance benefits by reducing the number of
times a table page needs to be read into the buffer pool.
Prerequisites
| Database Version |
Table Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- ALTER permission on the table.
- You own the table.
|
| SAP Sybase IQ
16.0 |
Requires one of:- ALTER ANY INDEX system privilege.
- ALTER ANY OBJECT system privilege.
- ALTER and REFERENCE permission on the table.
- You own the table.
|
-
The
SAP Sybase IQ resource is authenticated and running.
-
In a multiplex configuration, the coordinator node is
running.
-
The table exists in the system store.
Task- In the Perspective Resources view, select the resource and
select .
- In the Administration Console, expand .
- Select a catalog store table from the right pane and either:
- Click the arrow to the right of the name and select Set Clustered
Index, or
- From the Administration Console menu bar, select .
The Set Clustered Index Wizard appears.
- Select an index in the list of indexes. Set the clustered index:
| Field |
Description |
|---|
| Specify an index on this table to be clustered |
Select the check box to cluster the list of indexes. Any previously
clustered indexes in the list will no longer be clustered. If you clear the
check box, the currently clustered index will be unclustered. |
- Click OK.