CREATE INDEX Statement

Syntax 

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

Substitutable Fields

index_identifier

A unique identifier (name) for the index.

table_identifier

The unique identifier (name) for a table.

materialized_window_identifier

The unique identifier (name) for a materialized window.

column_identifier

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

Discussion

Secondary indexes can be based on one or more table columns or fields in a tuple held in a materialized window. Optionally, whether a BTREE (the default) or HASH is used for ordering the index values can be specified.

Related Topics

Back to Top ^