What problem are you trying to solve?

Focus on the what and why of the need you have, not the how you'd like it solved.

I have found out that the order of attributes in my (different) $match stages are relevant to the query planner of what index to choose.

What would you like to see happen?

Describe the desired outcome or enhancement.

Since there was only a lot of filter conditions and one sorter, there would have been a correct index to use.I would love to see an option (per execution or even global where the query planner can reorganize the order of attributes from one (or if safe) more $matches or filter and check if there is one better fitting index (with more entries than only the first one)

Why is this important to you or your team?

Explain how the request adds value or solves a business need.

since we can not always control everything in our aggregations and queries due to user dynamic input, this could ensure us a lot of efficiency and speed.

What steps, if any, are you taking today to manage this problemTracing, reorganizing

tracing and reorganising queries and indexes