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

        Activity

          People

            psergei Sergei Petrunia
            hholzgra Hartmut Holzgraefe
            Votes:
            2 Vote for this issue
            Watchers:
            10 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 0.25d
                0.25d

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.