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 Atlas
Created by Guest
Created on Aug 10, 2023

Improve Atlas suggested indexes

Suggested indexes - Currently it will suggest indexes that can't be created, such as with multiple array fields. -- This should be detectable before suggesting an index. -- Highlight array fields in the suggested index - Include partial index expressions - Make more than one suggestion for queries Trying to create an index that contains multiple array fields (for some documents being indexed) won't fail until it hits one such document. - Pre-parse to first confirm the fields being indexed don't include more than 1 array for the index? - Pre-parse and inform the user if any of the fields are arrays for the index scope - Pre-parse and make suggestions, like partial index expressions Query execution planner - It appears that the query execution planner doesn't take into account partial index expressions. E.g. there's a partial index expression enforcing field A = "abc" but you still need to include field A in the index for the planner to pick it.