Sybase IQ creates a High_Group index by default whenever you issue a CREATE INDEX statement without specifying an index type.
Sybase IQ automatically creates a High_Group index for any UNIQUE, FORIEGN KEY, or PRIMARY KEY constraint. For foreign keys of a single column, Sybase IQ creates a single column non-unique High_Group index. For multicolumn foreign keys, a non-unique composite High_Group index is implicitly created. The non-unique HG index allows duplicate values and optionally allows nulls. It provides the building block for referential integrity and can be used to improve query performance.
Queries with joins on multiple columns or multicolumn group by clauses may improve performance because a non-unique composite High Group index provides more accurate cardinality estimates of joins and result sizes. It can also optimize pushdowns and subqueries.
