CREATE INDEX

Creates a new index object in the database.

Syntax

CREATE [ UNIQUE | CLUSTER | UNIQUE CLUSTER ] INDEX
       [ IF NOT EXISTS ] index-name
 ON table-specification
    ( column-name [ ASCENCDING | DESCENDING ]  [,...] )