#查看表的所有索引
show index from tblname;
#删除表的索引
drop index index_name on tblname;
#表添加索引(btree)
alter table tblname add index using btree(column_name);
转载于:https://www.cnblogs.com/yako/p/3782845.html
