Pushdown indexed predicates to IXSCAN stage for full index plan over hashed indexes

XMLWordPrintableJSON

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

      SERVER-12769 improves handling of full IXSCAN plans by pushing down filters to the IXSCAN stage, however it is currently skipping it when indexes are hashed since it would be missing results as the filter is potentially removed from the FETCH stage required. For hashed indexes the fetch + filter should still stay. And the filter should be still pushed down to minimise the number of fetched docs.

            Assignee:
            Unassigned
            Reporter:
            Carlos Alonso Pérez
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: