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

Document optimizer's decision tree

    XMLWordPrintable

Details

    Description

      Some users would like to see the documentation include a decision tree for the optimizer, so those users can better understand the decisions that the optimizer makes. This would help those users find bugs in the optimizer and would better allow them to determine why the optimizer chooses different plans on different systems.

      Some things that this documentation could touch on are:

      • How join order is determined.
      • How it determines what index to use.
      • How it determines whether to use a particular optimization strategy.

      Attachments

        Issue Links

          Activity

            People

              dbart Daniel Bartholomew
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 0.75d
                  0.75d
                  Remaining:
                  Remaining Estimate - 0.75d
                  0.75d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Git Integration

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