Creating An Index

The CREATE INDEX command is used to establish an index. The form of this command is:

CREATE INDEX index-name
     ON table-name (column-name [DESC] [, column-name [DESC]] ...)
     [WITH option-name [value] [option-name [value] ...]] ;