Improve query performance for all_projects_pages_domains query
What does this MR do and why?
When working on Users should finish onboarding if they are clai... (#520498 - closed), it came up in pairing with @terrichu, from the analysis of work being done in determining eligibility for a user being associated with an enterprise group that one of the queries, that is potentially expensive could be improved.
- use all_projects_ids instead of all_projects to improve query performance.
- see &11469 (closed) for improvement case for using.
- see #520498 (closed)
Changelog: performance EE: true
DB analysis
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Related to #520498 (closed)
Edited by Doug Stull