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	Requires one of: DBA authority. You own the materialized view.
SAP Sybase IQ 16.0	Requires 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, select IQ Servers > Schema Objects > Views > Materialized Views.
Select a single materialized view in the right pane, click the drop-down arrow that appears to the right, and select Set Clustered Index.
In the list of indexes, confirm the index you want to cluster. Clicking any index sets its Clustered value to Yes and changes all other Clustered values to No.