don't FETCH when expr has tight bounds of same type

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • None
    • 3
    • TBD
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Similar to SERVER-41252 doing work not to fetch when we have `$expr` and `$eq`, we should not need to FETCH when we have GT/LT which generated tight bounds (of the same type).  So if the query was `$expr` with  field greater than a date and less than a date and we are using a non-multikey index, we do NOT need to FETCH since we will know from the index use with tight bounds that there is nothing left to `filter` during FETCH.

       

       

      Related to SERVER-69680

            Assignee:
            Unassigned
            Reporter:
            Asya Kamsky
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated: