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

Optimizer trace support for different parts of the server

    XMLWordPrintable

Details

    Description

      This task is for checking how optimizer trace uses different parts of the server.

      Done:

      • Condition transformation (DONE)
      • KEYUSE objects (DONE)
      • Range access (DONE)

      Not yet handled:

      • EITS: condition selectivities computed for each table (TODO, see below)
      • "Late" ORDER BY optimization (less-defined TODO, see some notes below)
      • Join optimization tracing (TODO: how to do it?)
      • Derived table merging
      • Conversion of subqueries into semi-joins
      • Table elimination

      Attachments

        Issue Links

          Activity

            People

              varun Varun Gupta (Inactive)
              psergei Sergei Petrunia
              Votes:
              1 Vote for this issue
              Watchers:
              3 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.