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

Semi-join optimization for single-table UPDATE/DELETEs

    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

          Activity

            People

            • Assignee:
              cvicentiu Vicentiu Ciorbaru
              Reporter:
              psergey Sergei Petrunia
            • Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: