[SERVER-74442] [CQF] Fast estimation on _id Created: 28/Feb/23  Updated: 29/Oct/23  Resolved: 14/Mar/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.0.0-rc0

Type: Improvement Priority: Major - P3
Reporter: Svilen Mihaylov (Inactive) Assignee: Jennifer Peshansky (Inactive)
Resolution: Fixed Votes: 0
Labels: cascades-starter
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Participants:

 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.



 Comments   
Comment by Githook User [ 14/Mar/23 ]

Author:

{'name': 'Jennifer Peshansky', 'email': 'jennifer.peshansky@mongodb.com', 'username': 'jenniferpeshansky'}

Message: SERVER-74442 [CQF] Assume cardinality 1 for equality predicates on _id
Branch: master
https://github.com/mongodb/mongo/commit/b6faca95a7e9d5fa142995f90de7b3d5090a450b

Generated at Thu Feb 08 06:27:27 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.