consider a collection with following documents:
{_id:1, prop:‘aaa’, field:[1,4,5]},
{_id:2, prop:‘bbb’, field:[2,4,5,10]},
{_id:3, prop:‘aaa’, field:[1,2,3,4,5]},
{_id:4, prop:‘aaa’, field:[1,2,3]},
{_id:5, prop:‘ccc’, field:2},
{_id:6, prop:‘ccc’, field:[3,5]},
{_id:7, prop:‘ccc’, field:1}
is index on field points records as
1: [1,3,4,7]
2: [2,3,4,5}
3: [3,4,6]
4:[1,2,3]
5:[3,4,5]
How does range query work on multikey? For example, how does query db.collection.find({“field”: {“$gte”: 2,“$lte”:4}}) work?