[SERVER-79062] Either block from lowering to SBE or support whole bucket match TS queries Created: 18/Jul/23  Updated: 17/Oct/23  Resolved: 23/Aug/23

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

Type: Task Priority: Major - P3
Reporter: Irina Yatsenko (Inactive) Assignee: Backlog - Query Integration
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-79699 Support wholeBucketFilter in the Unpa... Closed
Assigned Teams:
Query Integration
Participants:

 Description   

This optimization is done for $match on the time field (the value in $match must be of type BSONDate, the optimization doesn't kick in for doubles) and avoids applying the event filter to each measurement in the bucket. The optimization is implemented via an optional state on $_internalUnpackBucket.

According to Arun Banala the optimization improved the eligible queries by up to 30% so we don’t want to lose it but if it ends up tricky to implement in SBE we would need to block these queries from being lowered.


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