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 |
You must have one of:- DBA authority
- ALTER permission on the table
- You own the table
|
| SAP Sybase IQ
16.0 |
You must have 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 left pane, expand , and then select
Tables.
- Select an IQ 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. 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.
- 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.