Improve SyncScanResultPoliciesService performance
What does this MR do and why?
This slightly improves DB query performance in SyncScanResultPoliciesService
by only selecting id
from projects
.
💾 Database
Old query
New query
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 #407269 (closed)