Creating Indexes

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:
- Enter a CREATE INDEX statement.
  For example, create a High_Non_Group (HNG) index called ShipIx on the ShipDate column of the SalesOrderItemstable.
```
CREATE HNG INDEX ShipIx 
  ON dbo.SalesOrderItems (ShipDate)
```
- Use the Sybase Control Center Create Index wizard.
- Use a PRIMARY KEY, or UNIQUE column constraint of CREATE TABLE, which creates an HG index automatically.

Concurrent Column Indexing
In some cases, you can create more than one column index simultaneously.
Status Messages for Index Loading
If you enable progress messages, status messages display after every 100,000 records are inserted.
Adding Column Indexes After Inserting Data
When you create an additional column index, the CREATE INDEX command creates the new index as part of the individual table.
Executing Groups of CREATE INDEX Statements
Use the keywords BEGIN PARALLEL IQ and END PARALLEL IQ to delimit any number of CREATE INDEX statements that you want to execute as a group at the same time.

Parent topic: Index SAP Sybase IQ Columns

Related reference

CREATE INDEX Statement

CREATE TABLE Statement