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.
- 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.
- 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.
1
vote
