Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20519

Query plan regression with optimizer_use_condition_selectivity > 1

    XMLWordPrintable

    Details

      Description

      The optimizer can choose very bad execution plans for certain queries with the default optimizer_use_condition_selectivity=4 in MariaDB 10.4. Setting optimizer_use_condition_selectivity=1 allows you to work around the problem.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              varun Varun Gupta
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: