设置索引可见不可见,看索引效率

设置索引可见不可见,看索引效率,若效率不受影响,可删除索引

alter table table_name ALTER index app_id visible/invisible

SET SESSION optimizer switch="use_invisible_indexes=on";