CREATE INDEX

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