Tools for Creating Sybase IQ Indexes

You can create a column index explicitly using either of two tools.

Interactive SQL

To create a Sybase IQ column index, use the SQL syntax in Reference: Statements and Options > SQL Statements > CREATE INDEX statement.

To create a Sybase IQ column index, use the SQL syntax in Reference: Statements and Options > SQL Statements > CREATE INDEX statement.
Sybase Central

To create a column index using Sybase Central, see “Creating Column Indexes” in Introduction to Sybase IQ > Indexing and Loading Data.

Interactive SQL Index Creation
If you do not specify an index-type, Sybase IQ creates an HG index.
Concurrent Column Index Creation
In some cases, you can create more than one column index at the same time.

Parent topic: Sybase IQ Indexes