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

Extend Heuristic CE for Sargable node to take into account Traverse

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 6.2.0-rc0
    • None
    • None
    • Fully Compatible
    • QO 2022-08-22, QO 2022-10-31

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: