MongoDB not using wildcard nested array index

Working with Data
5

Hi @Pavel_Duchovny :slight_smile:

  1. Yes I’m filtering a certain array element index like above.

  2. I tried $arrayElementAt but it was extremely slow

  3. Hinting the multikey index did not help

  4. To summarize, the fastest index is quizzes.0.done

  5. Can you please add a feature request for a new variation of a wildcard index like quizzes.$**.done so that we don’t have to create quizzes.0.done , quizzes.1.done , quizzes.2.done …etc?
    That would be very helpful.

Thanks again Pavel for your effort.
Regards