You can create column indexes in three ways:
With the CREATE INDEX command
With the Index Creation wizard in Sybase Central
With the UNIQUE or PRIMARY KEY column constraint of CREATE TABLE, which creates a unique index automatically.
You can create a join index in two ways:
With the CREATE JOIN INDEX statement
With the Create Join Index wizard in Sybase Central
See Chapter 6, “Using Sybase IQ Indexes” for details on selecting and creating indexes. See CREATE INDEX statement and CREATE JOIN INDEX statement in Reference: Statements and Options for command syntax. See Chapter 5, “Indexing and Loading Data” in the Introduction to Sybase IQ for Sybase Central instructions.
