True, but I think this doesn't help much in the case I mentioned. In my case all duplicate indexes were used, but still most of them could be dropped without damages. In a few cases however there was a FORCE INDEX or IGNORE INDEX, so after the drop, some queries started to fail.
Thanks Sveta,
True, but I think this doesn't help much in the case I mentioned. In my case all duplicate indexes were used, but still most of them could be dropped without damages. In a few cases however there was a FORCE INDEX or IGNORE INDEX, so after the drop, some queries started to fail.