Skip to content

DEV Community

ESR (Equality, Sort, Range) Indexes Series' Articles

Back to Franck Pachot's Series

Franck Pachot for MongoDB

Feb 11 '25

MongoDB Equality, Sort, Range (ESR) without Equality (SR): add an unbounded range predicate on the indexed sort field

#mongodb #indexing #database #webdev

5 min read

Franck Pachot for MongoDB

Feb 27 '25

Skip Scan in MongoDB with Range, Equality (RE) index as an alternative to Equality, Sort, Range (ESR)

#mongodb #database #indexing #webdev

4 min read

Franck Pachot for MongoDB

Feb 27 '25

Order-preserving or-expansion in MongoDB and $in:[,,] treated as a range skip scan, or exploded to an equality for the ESR rule

#postgres #index #sort #webdev

5 min read