The ESR (Equality, Sort, Range) Rule — MongoDB Manual
www.mongodb.com/docs/manual/tutorial/equality-sort-range-rule/
1 Users
0 Comments
4 Highlights
0 Notes
Tags
Top Highlights
Place fields that require exact matches first in your index.
Exact matches should be selective. To reduce the number of index keys scanned, ensure equality tests eliminate at least 90% of possible document matches.
Sort operations on a subset of the index keys are only supported if the query includes equality conditions for all of the prefix keys that precede the sort keys. For more information see: Sort and Non-prefix Subset of an Index
MongoDB cannot do an index sort on the results of a range filter.
Ready to highlight and find good content?
Glasp is a social web highlighter that people can highlight and organize quotes and thoughts from the web, and access other like-minded people’s learning.