Skip to main content
Version: 2.5

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