Saluwaruh indeks singel-field dasar, MongoDB menawarake strategi indeksing canggih — compound index ordering (ESR rule), covered queries, partial/sparse indexes, TTL indexes, lan liyane — sing kritis mpengaruhi performance query. Menguasai dheweke minangka kunci kanggo optimasi MongoDB ing skala gedhe.
ESR rule kanggo compound indexes
For a compound index supporting a query with Equality, Sort, and Range conditions,
order the fields: EQUALITY → SORT → RANGE (the ESR rule).
