CREATE INDEX

description

This statement is used to create index
grammer:
    CREATE INDEX index_name ON table_name (column [, ...],) [USING BITMAP] [COMMENT'balabala'];
note:
    1. only support bitmap index in current version
    2. BITMAP index only supports apply to single column

example

1. create index on table1 column siteid using bitmap 
    CREATE INDEX index_name ON table1 (siteid) USING BITMAP COMMENT 'balabala';

keyword

CREATE,INDEX