Edit

CREATE INDEX

Description

This statement is used to create indexes.

Syntax:

CREATE INDEX index_name ON table_name (column [, ...],) [USING BITMAP] [COMMENT'balabala'];

Note:

  1. Only support bitmap index in the current version.
  2. Create BITMAP index only in a single column.

Examples

  1. Create bitmap index for siteid on table1.

    CREATE INDEX index_name ON table1 (siteid) USING BITMAP COMMENT 'balabala';