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

Semi-join optimization for single-table UPDATE/DELETEs

    XMLWordPrintable

    Details

      Description

      Currently, single-table UPDATE/DELETE statements cannot take advantage of semi-join optimizations. This is because semi-join optimizations are parts of join optimization (which is not invoked for single-table UPDATE/DELETE).

      This task is about

      • detecting UPDATE/DELETEs that can use semi-join optimizations
      • switching those queries to be processed as multi-table UPDATE/DELETEs. This will enable semi-join optimizations.

      Note that we do similar things for VIEWs: UPDATE multi_table_view SET =... is switched to be processed as multi-table UPDATE as soon as the server discovers that we're updating a multi-table VIEW.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              psergei Sergei Petrunia
              Reporter:
              psergei Sergei Petrunia
              Votes:
              4 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated: