How would the ESR rule of Indexes behave if one of the fields is optional?

The best is to try alternatives and to compare the explain plans. Start with https://www.mongodb.com/docs/manual/tutorial/analyze-query-plan/.

1 Like