CREATE INDEX creates an index on the specified table for the specified column(s).

CREATE INDEX index_name ON table_name (column_name [,column_name])

This statement accomplishes the same task as the TCL command create-index, creating a new b-tree index on the underlying D3 file using the a processing code and the attribute number(s) corresponding to the specified column(s). The index is used by the query optimizer to speed up queries involving the specified column(s).

The index name is a user-defined name also used by DROP INDEX to drop the index.