删除索引的语法形式: 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;--------------------------------------------------
本文共 275 字,大约阅读时间需要 1 分钟。
删除索引的语法形式: 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;--------------------------------------------------
转载于:https://blog.51cto.com/xin521long/1832442