Create column indexes and join indexes.
With the CREATE INDEX statement
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.
With the CREATE JOIN INDEX statement
With the Create Join Index wizard in Sybase Central