Also remove existing redundant index, the new index can be used the same
way.

See
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/62634#note_591636460.

Changelog: other