[SERVER-53758] Map predicates on min time to a portion of _id Created: 13/Jan/21  Updated: 29/Oct/23  Resolved: 03/Mar/21

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: 4.9.0

Type: Task Priority: Major - P3
Reporter: Jacob Evans Assignee: Katherine Wu (Inactive)
Resolution: Fixed Votes: 0
Labels: qopt-team
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-54409 Extend SBE stage builder to support b... Closed
Backwards Compatibility: Fully Compatible
Sprint: Query Optimization 2021-02-22, Query Optimization 2021-03-08
Participants:

 Description   

As part of the time-series schema, min time is embedded into _id. In addition to using the control.min.time field, map min time predicates to predicates on time to the min time portion of _id as well. This should lead to guaranteed index utilization. This should be done inside $unpackBucket's doOptimizeAt() for $eq, $gt, $lt, $gte, $lte only.



 Comments   
Comment by Githook User [ 03/Mar/21 ]

Author:

{'name': 'Katherine Wu', 'email': 'katherine.wu@mongodb.com', 'username': 'kaywux'}

Message: SERVER-53758 Map predicates on min time to a portion of _id
Branch: master
https://github.com/mongodb/mongo/commit/8a04ca462a9e478a7ce19a1db368858c2056a32c

Generated at Thu Feb 08 05:31:47 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.