Add index to oauth_access_grants.application_id
What does this MR do and why?
This MR adds an index to the application_id
column to fix the timeout error when removing oauth applications. Internal issue: https://gitlab.com/gitlab-com/support/internal-requests/-/issues/18610
The table contains about 50m rows but it doesn't seem to be a high traffic table (not in the list).
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Related to #393247 (closed)
Edited by Adam Hegyi