You can automate indexing for certain columns by creating a table with either PRIMARY KEY or UNIQUE constraints.
These options cause Sybase IQ to create an HG index for the column that enforces uniqueness.
If you use the ALTER TABLE command to add a UNIQUE column to an existing table, or to designate an existing column as UNIQUE, an HG index is created automatically.