CREATE INDEX
Descriptionβ
This statement is used to create indexes.
Syntax:
CREATE INDEX index_name ON table_name (column [, ...],) [USING BITMAP] [COMMENT'balabala']
Note:
- Only support bitmap index in the current version.
- Create BITMAP index only in a single column.
Examplesβ
-
Create bitmap index for
siteid
ontable1
.CREATE INDEX index_name ON table1 (siteid) USING BITMAP COMMENT 'balabala';