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

Print ranges in the optimizer trace created for non-indexed columns when optimizer_use_condition_selectivity >2

    XMLWordPrintable

Details

    Description

      For non-indexed columns ranges are created when optimizer_use_condition_selectivity > 2 and with the help of EITS we are able to make estimates for predicates which involved non-indexed columns.

      Eg:

         SELECT * FROM t1 WHERE a = 10;
      

      If there is no index on column a we will create a range for a=10 and get the statistics from EITS. It would be good to print this range in the optimizer trace too.
      We already print ranges for indexed columns in the optimizer trace.

      Attachments

        Activity

          People

            varun Varun Gupta (Inactive)
            varun Varun Gupta (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.