ExportXMLWordPrintableJSON

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

      Every failure in singleTableAccessPlans() is reported as failedToGetSingleTableAccessViaCBR by the executor. That includes:

      • planning or CBR errors
      • CBR accepting several plans it can't rank
      • the single plan CBR can't estimate (SERVER-138000)

      SERVER-134637 will add another: falling back when a node's chosen plan uses a hashed, wildcard or collated index. These cases look the same in serverStatus and $queryStats.

      Consider having singleTableAccessPlans() return a specific fallback reason, and add new reasons where needed, starting with the hashed/wildcard/collated index case.

            Assignee:
            Alya Berciu
            Reporter:
            Max Verbinnen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: