Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18511 CTE support for UPDATE and DELETE statements
  3. MDEV-21012

Very bad query optimization on DELETE with subquery

    XMLWordPrintable

Details

    Description

      DELETEs using "WHERE ... IN (SELECT ...)" subquery syntax are much slower than DELETEs using the multi query delete syntax and a JOIN instead of a subquery.

      Original, still active, upstream report on the MySQL side is:

      https://bugs.mysql.com/bug.php?id=35794

      Attachments

        Issue Links

          is part of

          New Feature - A new feature of the product, which has yet to be developed. MDEV-18511 CTE support for UPDATE and DELETE statements

          • Major - Major loss of function.
          • Stalled

          Activity

            People

              psergei Sergei Petrunia
              hholzgra Hartmut Holzgraefe
              Votes:
              2 Vote for this issue
              Watchers:
              10 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.