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

With large number of indexes optimizer chooses an inefficient plan

Details

    Description

      With a large number of indexes the optimizer picks the wrong path.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24117 Memory management problem in statistics state for queries that have a large field IN (values) part

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          mentioned in

          Page Loading...

          Activity

            Transition Time In Source Status Execution Times
            Igor Babaev (Inactive) made transition -
            Open In Progress
            		1d 23h 19m 1
            Igor Babaev (Inactive) made transition -
            In Progress In Review
            		30s 1
            Sergei Petrunia made transition -
            In Review Stalled
            		10d 18m 1
            Igor Babaev (Inactive) made transition -
            Stalled Closed
            		2d 37m 1

            People

              igor Igor Babaev (Inactive)
              kjoiner Kyle Joiner (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.