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

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

        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.