Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-79062

Either block from lowering to SBE or support whole bucket match TS queries

    • Type: Icon: Task Task
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Query Integration

      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.

            Assignee:
            backlog-query-integration [DO NOT USE] Backlog - Query Integration
            Reporter:
            irina.yatsenko@mongodb.com Irina Yatsenko (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: