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

Fix table selectivity by sampling some probably very selective predicates

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      There are some predicates like 'table.field LIKE %WORD' which probably very selective but it is impossible judge about them by index or other statistics we collect now.

      We can just check the predicate against some rows in the table.

      In the beginning it will be first N rows of the table.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              sanja Oleksandr Byelkin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration