Draft: Use InOperatorOptimization to optimize Group#sbom_occurrences query
What does this MR do and why?
This change attempts to optimize the Group#sbom_occurrences
query using the techniques described in https://docs.gitlab.com/ee/development/database/efficient_in_operator_queries.html.
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.