CREATE INDEX
Description
This statement is used to create indexes.
tip
This operation requires the ALTER privilege on the target table. You can follow the instructions in GRANT to grant this privilege.
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';