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

Map predicates on max time to a portion of _id

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 4.9.0
    • Affects Version/s: None
    • Component/s: Querying
    • Labels:
    • Fully Compatible
    • Query Optimization 2021-03-22, Query Optimization 2021-04-05, Query Optimization 2021-04-19

      As part of the time-series schema, min time is embedded into _id. We can add the max bucket range to this to get an overestimate for max time. In addition to using the control.max.time field, we should map max time predicates to predicates on time to the min time portion of _id plus the bucket range. The 'plus' can be realized by subtracting from the user-provided predicate value in the query but we should guard against underflow. This should lead to guaranteed index utilization. This should be done inside $unpackBucket's doOptimizeAt() for $eq, $gt, $lt, $gte, $lte only.

            jacob.evans@mongodb.com Jacob Evans
            jacob.evans@mongodb.com Jacob Evans
            0 Vote for this issue
            3 Start watching this issue