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

[CQF] Fix for residual predicate selectivity estimation

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 7.1.0-rc0
    • None
    • None
    • None
    • Fully Compatible
    • ALL
    • QO 2023-05-01

    Description

      When we estimate selectivity of residual predicates for a "Seek" sargable node, we apply the wrong denominator. We divide essentially by "1" instead of the group cardinality. This leads to incorrect selectivities and incorrect cost for the plan.

      Attachments

        Activity

          People

            svilen.mihaylov@mongodb.com Svilen Mihaylov (Inactive)
            svilen.mihaylov@mongodb.com Svilen Mihaylov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: