mysql 索引

建立索引

CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name
    [index_type]
ON tbl_name (index_col_name,...)
    [index_option]
    [algorithm_option | lock_option] ...

index_col_name:
    col_name [(length)] [ASC | DESC]

index_option:
    KEY_BLOCK_SIZE [=] value
  | index_type
  | WITH PARSER parser_name
  | COMMENT 'string'
  | {VISIBLE | INVISIBLE}

index_type:
USING {BTREE | HASH}

algorithm_option:
    ALGORITHM [=] {DEFAULT|INPLACE|COPY}

lock_option:
LOCK [=] {DEFAULT|NONE|SHARED|EXCLUSIVE}

删除索引（mysql）

DROP INDEX index_name ON table_name;

ALTER TABLE table_name DROP INDEX index_name;

sql sever
删除索引
drop index<表名。索引名>