Skip to Main Content

MongoByte MongoDB Logo

Welcome to the new MongoDB Feedback Portal!

{Improvement: "Your idea"}
We’ve upgraded our system to better capture and act on your feedback.
Your feedback is meaningful and helps us build better products.

Status Submitted
Categories Compass
Created by Guest
Created on Dec 18, 2024

Smart Index Optimization for Aggregation Queries in Compass

When building aggregation pipelines in Compass, sometimes queries can slow down if they’re missing the right indexes or opt out. 1. Creating Temporary Indexes Automatically: If the aggregation query doesn’t have an optimal index, Compass will automatically build a temporary one just for that specific operation. 2. Suggesting Permanent Indexes: After running the aggregation with the temporary index, Compass will notify you and suggest saving the index permanently if it’s likely to be useful for future queries. Maybe even showing time saved with the index or without.
  • Attach files