Have the planner consider partial indexes for optimized contained-$or queries

XMLWordPrintableJSON

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

      The logic to strip invalid assignments of predicates to partial indexes is unaware of the contained-$or pushdown optimization. The analysis of which tags need to be stripped due to the partial index filter happens before any code relating to the contained-$or pushdown optimization. In order to fix this, we need to somehow make the index selection logic for partial indexes aware of the contained-$or pushdown optimization.

            Assignee:
            [DO NOT USE] Backlog - Query Optimization
            Reporter:
            Eric Sedor
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated: