TurboDB Engine Documentation
CREATE INDEX
Previous  Top  Next


Creates a new index for an existing table.

CREATE INDEX index_reference ON table_reference (column_reference [ASC|DESC] [,column_reference [ASC|DESC] ...] )

Description
Indexes are used to speed up query execution. Use the CREATE INDEX command to add a new index to an existing table:
CREATE INDEX OrderIdIdx ON Orders (OrderId ASC)

You may create multi-level hierarchical indexes as well:
CREATE INDEX TargetDateIdx ON Orders (DeliveryDate DESC, OrderId)

Note
The ASC and DESC attribute at column level is a proprietary extension to SQL-92.