Cover null query when other indexed field doesn't match null

XMLWordPrintableJSON

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

      Say we have a non-multikey index {x: 1, y: 1}

      The query with filter {x: null, y: {$eq: 1}} and projection {_id: 0, y: 1} can be covered, since we never actually need to distinguish between x values

            Assignee:
            Unassigned
            Reporter:
            Alya Berciu
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated: