Details
-
Task
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
Fully Compatible
-
Execution Team 2022-01-10, Execution Team 2022-01-24, Execution Team 2022-02-07, Execution Team 2022-02-21
Description
A range query using an index likeĀ find({a:{$lte:"yadda")}} generates tight bounds:
"indexBounds" : {
|
"a" : [
|
"[\"\", \"yadda\"]"
|
]
|
By contrast, a range query by the cluster key likeĀ find({_id:{$lte:"yadda")}} generates only a single bound:
"winningPlan" : {
|
"stage" : "COLLSCAN",
|
"filter" : {
|
"_id" : {
|
"$lte" : "yadda"
|
}
|
},
|
"direction" : "forward",
|
"maxRecord" : "yadda"
|
},
|
This range query can be quite inefficient as it fetches any document of lower data type, like numeric types.