Extend Heuristic CE for Sargable node to take into account Traverse

XMLWordPrintableJSON

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

      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
              Reporter:
              Timour Katchaounov
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: