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

              Assignee:
              varun Varun Gupta
              Reporter:
              psergey Sergei Petrunia
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: