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

            Assignee:
            varun Varun Gupta
            Reporter:
            varun Varun Gupta
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: