Setting a Clustered Index

Using a clustered index increases the chance that two rows from adjacent index entries will appear on the same page in the database. This 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	Materialized View Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You own the materialized view
SAP Sybase IQ 16.0	You must have one of: ALTER ANY MATERIALIZED VIEW system privilege ALTER ANY OBJECT system privilege You own the materialized view

The SAP Sybase IQ resource is authenticated and running.
In a multiplex configuration, the coordinator node is running.
The materialized view is enabled.
At least one index for the materialized view exists.

Task

Materialized view data is read-only. Materialized views are only supported for system store (IQ catalog store) tables.

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 Set Clustered Index, or
- From the Administration Console menu bar, select Resource > Set Clustered Index.
In the list of indexes, select an index and click OK.
The Clustered value for the index is set to Yes and changes the Clustered value on all other indexes listed to No.