Zaidi ya single-field indexes za msingi, MongoDB hutoa mikakati ya hali ya juu ya indexing — mpangilio wa compound index (kanuni ya ESR), covered queries, partial/sparse indexes, TTL indexes, na zaidi — ambazo huathiri sana utendaji wa query. Kuzimiliki ni muhimu kwa kuboresha MongoDB katika kiwango kikubwa.
Kanuni ya ESR kwa compound indexes
For a compound index supporting a query with Equality, Sort, and Range conditions,
order the fields: EQUALITY → SORT → RANGE (the ESR rule).
