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 New Join Index wizard in Sybase Central
See Chapter 6, “Using Sybase IQ Indexes” for details on selecting and creating indexes. See the Sybase IQ Reference Manual for command syntax. See Chapter 5, “Indexing and Loading Data” in the Introduction to Sybase IQ for Sybase Central instructions.
