Product Solutions Support
Try MemSQL

CREATE INDEX

Create an index on the specified table.

CREATE [UNIQUE] INDEX index_name [index_type] ON tbl_name (index_col_name,...) [index_option]

index_col_name:
    col_name [ASC | DESC]

index_type:
    USING { BTREE | HASH }

index_option:
  | index_type
  | COMMENT 'string'

Notes

Example

memsql> CREATE INDEX seq_index ON mytbl (seq);
Query OK, 0 rows affected (9.11 sec)
Records: 0  Duplicates: 0  Warnings: 0
Was this article useful?