Investigate whether SBE plans generated by the join optimizer yield frequently enough

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

      The join optimizer produces new kinds of SBE plans which may have different data access patterns than plans generated in the past. We should investigate whether the SBE engine's yielding behavior is sufficient, or whether it is possible for the join optimizer to generate a plan that (depending on the shape of the data) may not yield for seconds or minutes. My recollection is that SBE plans currently trigger yielding at the leave stages doing data access (scan or ixscan), but perhaps it is possible to generate a join plan which spends lots of time processing intermediate results without ever accessing the base collections.

            Assignee:
            Unassigned
            Reporter:
            David Storch
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: