1 2 3 4 5 6 7 8 9 10 11 12 13 |
CREATE INDEX ============ CREATE [UNIQUE] INDEX index_name [USING {BTREE | HASH}] ON table_name (column_name [length] [ASC | DESC], ...); An example: CREATE INDEX table_1_index ON table_1 (a,b); This would create an index on table_t named table_1_index that convered columns a and b. FIXME: how this is implemented currently. i.e. no fast add index |