Remove various redundant indexes
What does this MR do?
This MR removes various redundant and unused indexes. See c3d5c536 for more information.
Are there points in the code the reviewer needs to double check?
No.
Why was this MR needed?
Unused indexes are a waste of storage space and slow down database writes. If they are ever needed again we can re-create them. There's no point in hoarding indexes because you may need them in the future.
What are the relevant issue numbers?
Screenshots (if relevant)
Does this MR meet the acceptance criteria?
-
CHANGELOG entry added - Tests
-
All builds are passing
-
-
Conform by the style guides -
Branch has no merge conflicts with master(if you do - rebase it please) -
Squashed related commits together