CREATE-INDEX
CREATE-INDEX
Name
CREATE INDEX
Description
该语句用于创建索引 语法:
CREATE INDEX [IF NOT EXISTS] index_name ON table_name (column [, ...],) [USING INVERTED] [COMMENT'balabala'];
注意:
- 倒排索引仅在单列上创建
Example
在table1 上为siteid 创建倒排索引
CREATE INDEX [IF NOT EXISTS] index_name ON table1 (siteid) USING INVERTED COMMENT 'balabala';
Keywords
CREATE, INDEX