When a new composite index is added, it might make an existing index redundant. So when adding an index, these redundant indexes should be removed in the same migration.