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

LP:639949 - Non optimal index choice, depending on index creation order

    XMLWordPrintable

    Details

      Description

      Hi,

      There are several simple cases where MySQL optimiser doesn't select the right index. This entails strong performance issues, and force the developers to hack their applications, using USE INDEX (when it's possible...)

      This wrong optimizer behaviour is explained in detail here : http://bugs.mysql.com/bug.php?id=36817

      The bugs also occurs both in MariaDB 5.1 & 5.2.

      Since this bug is around for more than 2 years now, I really hope it could be fixed really soon in MariaDB.

      Thanks and regards,
      Jocelyn Fournier

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              jocelynfournier jocelyn fournier
              Votes:
              0 Vote for this issue
              Watchers:
              0 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.