删除索引的语法形式:

drop index index_name on table_name;

for example: drop index index_dname_loc on t_dept;

show create table t_dept \G;

explain select * from t_dept where dname ='cj' \G;
--------------------------------------------------