CREATE INDEX

CREATE INDEX index_name
    ON table-name (
    column-name 
    [ , column-name] * ) 

Description

The CREATE INDEX statement creates an index on one or more columns of a table. Indexes can speed up queries that use those columns for filtering data, or can also enforce a unique constraint on the indexed columns.

Note

CREATE INDEX is currently under development for column tables and does not work if the data is updated.

Example

Create an index on two columns:

CREATE INDEX idx ON FLIGHTS (flight_id, segment_number);