Creating an Index

Utilities

Through the isql/dbaccess menu-driven form for creating a table

This is rather limited as:

It only creates indexes at the time of the creation of the table. It creates a Unique index on SERIAL columns automatically. It does not allow composite indexes to be created.

It does not allow Cluster indexes to be created.

SQL statement

The syntax of the statement is:

CREATE [UNIQUE I DISTINCT] [CLUSTER] INDEX index_name ON table_name (column name [ASC I DESC] ....

The options UNIQUE and DISTINCT mean the same.

By default, an index permits Duplicates.

By default, columns are indexed in ascending order. An index may be dropped at any time, using the statement:

DROP INDEX index_name