Engine selection should return top-most QuerySolutionNode eligible for SBE

XMLWordPrintableJSON

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

      Currently engine selection returns the chosen engine, classic or SBE. However we've run into scenarios where we may accidentally disable some queries from using SBE in 9.0 that previously used SBE in 8.0:

      collscan - $group - $lookup - $unwind

      If we choose to not enable $LU for collscan plans (just as an example), we would want engine selection to indicate that the $group will use SBE, but the $LU will use classic.

            Assignee:
            Felipe Goron Farinon
            Reporter:
            Matt Boros
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: