SAP Sybase IQ automatically creates a default index on every
table column when you create a database in an IQ store. For best query performance, create
additional indexes.
Prerequisites
If you are creating an index on a partitioned
table, all dbspaces must be online.
Task- Choose the right index type for your data. Make sure that the selected index type
allows the data type for that column.
If you do not specify an index type, SAP Sybase IQ creates
an HG index. Several front-end tools create an
HG index automatically for this reason.
- Create an index using any method: