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

Improve performance pushing down full query for using index for group by

    XMLWordPrintable

Details

    Description

      Running

      • SELECT DISTINCT idx1 FROM t1
      • SELECT idx1 FROM t1 GROUP BY idx1

      if idx1 as low cardinality it is always more interesting to map reduce the query as most of the data will be reduce first in the backend using the index, sending less network traffic to the spider node

      Workaround was identify by using

      • SELECT DISTINCT idx1 FROM t1 ORDER BY idx1 limit 100000
      • Using spider_direct_sql UDF

      Attachments

        Activity

          People

            ycp Yuchen Pei
            stephane@skysql.com VAROQUI Stephane
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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