Improve index usage of queries to approval_merge_request_rules and approval_project_rules

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

Background

As @acroitor suggested in !142169 (comment 1760515789), we can improve index usage of some queries.

Proposal

Look into if adding a new index or updating existing indexes can help improve queries further.