Redundant / unused issues indexes synchronous removal

Summary

This issue is to add a migration(s) to create/destroy the database indexes synchronously after it has been created/destroyed on GitLab.com.

The asynchronous indexes was introduced in !189036 (merged) and !189484 (merged).