Home > Documentation > CREATE INDEX Statement

CREATE INDEX Statement

Syntax

CREATE INDEX index_identifier ON table_identifier
  [USING {HASH | BTREE}] (
    column_identifier[,...]
  );

Substitutable Fields

index_identifier:

A unique identifier (name) for the index.

table_identifier:

The unique identifier (name) for the table.

column_identifier:

A unique identifier (name) for the column(s) in the table on which the index is based.

Discussion

Secondary indices may be based on one or more table columns. Optionally, whether a BTREE (the default) or HASH is used for ordering the index values may be specified.