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

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

          Transition Time In Source Status Execution Times
          Varun Gupta (Inactive) made transition -
          Open In Progress
          4d 2h 10m 1
          Varun Gupta (Inactive) made transition -
          In Progress In Review
          4h 45m 1
          Sergei Petrunia made transition -
          In Review Stalled
          21d 23h 25m 1
          Varun Gupta (Inactive) made transition -
          Stalled Closed
          1d 15h 17m 1

          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.