CREATE-INDEX
CREATE-INDEX
Name
CREATE INDEX
Description
This statement is used to create an index grammar:
CREATE INDEX [IF NOT EXISTS] index_name ON table_name (column [, ...],) [USING INVERTED] [COMMENT 'balabala'];
Notice:
- INVERTED indexes are only created on a single column
Example
Create a inverted index for siteid on table1
CREATE INDEX [IF NOT EXISTS] index_name ON table1 (siteid) USING INVERTED COMMENT 'balabala';
Keywords
CREATE, INDEX