Add plan rankerChoice to V3 explain

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Done
    • Priority: Major - P3
    • 9.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • Fully Compatible
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      rankerChoice: - the reason why a certain plan ranking algorithm was chosen, and which one

      • requestedRanker: the ranker that the internal logic understood to be requested
        one of: multiPlanning, costBased, Mixed/NoMultiplanningResults, Mixed/EstimateRankingEffort, none
      • chosenRanker: the ranker that chose the winning plan.
        One of: multiPlanning, costBased, none
      • reason: the reason why ‘chosenRanker’ was selected.
        One of: featureFlag, queryKnob, cbrCheaperThanMp, mpCheaperThanCbr, mpEarlyExitEofOrFullBatch, mpEarlyExitOrResult, noMultiplanningResults, singlePlan, inestimableNode, inestimableMP, histogramCEInternalColl, smallCollection.

        1.
        		 Add chosenRanker to explain V3 SERVER-132229 Sub-task Closed Nicholas Zolnierz 9.1.0-rc0
        2.
        		 Add requestedRanker to explain V3 and finalize the rankerChoice object SERVER-132230 Sub-task Closed Unassigned  
        3.
        		 Add reason to the rankerChoice object in explain V3 SERVER-132377 Sub-task Closed Timour Katchaounov 9.1.0-rc0

            Assignee:
            Nicholas Zolnierz
            Reporter:
            Nicholas Zolnierz
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: