Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-94988

Display CBR estimates in explain when there a single enumerated plan

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

      In the case of a single enumerated plan, we use SingleSolutionPassthroughPlanner which doesn't know anything about the estimates for the plan.

      It may be useful to display estimates in explain for this case. Otherwise users will have no way to examine estimate information without creating another index for the purpose of enumerating multiple plans. There may be internal uses cases as well when we hint indexes to evaluate the accuracy of our cost model.

      Attached is a diff in progress for supporting this capability.

      single-solution-costs.patch

            Assignee:
            Unassigned Unassigned
            Reporter:
            ben.shteinfeld@mongodb.com Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: