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

Extend Heuristic CE for Sargable node to take into account Traverse

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.2.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
    • Fully Compatible
    • QO 2022-08-22, QO 2022-10-31

      Heuristic CE for SargableNode should be symmetric to the analogous estimates for FilterNode. FilterNode increases selectivity by 10% when the path expression of a condition contains a PathTraverse node because this assumes there may be array data in the path.

      This task should do the same for heuristic estimation of SargableNode.

      The information about the path is stored inside the key of PartialSchemaRequirements, so should be easy to check.

            Assignee:
            alya.berciu@mongodb.com Alya Berciu
            Reporter:
            timour.katchaounov@mongodb.com Timour Katchaounov
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: