Queries against the Organizations collection are slower than expected, particularly during dashboard loading and role validation workflows.
Goals:
Review aggregation pipelines and conditional filters
Audit indexes and query selectivity
Explore partial indexes or splitting heavy documents if needed
