Details
-
Improvement
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
Query Optimization
-
Fully Compatible
Description
If we have a sargable node with an equality predicate on _id, do not ask CE framework for an estimate, instead assume cardinality is 1.
Longer term, similar reasoning should apply for any fields which may be constrained to be unique.