Prototype: Combine multiplanner and CBR to leverage CBR when multiplanner exhaust works

XMLWordPrintableJSON

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

      We want to leverage CBR for those cases where we think multiplanner will struggle. Initially that is defined to cases where multiplanner was not able to pick a plan after trial period. Use QueryPlanRankerMode knob to enable the feature. Specifically when set to "automaticCE". Work both for the classic and SBE multiplanners. Ignore subplanning.

      Given the uncertainty we want to come up with a working logic that can be measured vs the current implementation. Do not worry about code quality. Just prototype. It is not going to be merged into master.

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

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 3 days
                3d
                Logged:
                Time Spent - Not Specified
                Not Specified