Use column store for queries with small set of fields but no "lowerable" predicates

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Fixed
    • Priority: Major - P3
    • 6.0.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • QE 2022-04-04, QE 2022-03-21, QE 2022-04-18
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      Discussed during SERVER-63124. Since we are not competing a column store index vs. a "regular" index at this point, there are probably many cases where this could still be beneficial. We expect this might be slower if you're scanning a large number of columns but we can add a heuristic to allow small # of fields to use the column store.

            Assignee:
            Charlie Swanson
            Reporter:
            Charlie Swanson
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: