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.