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);