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

Fix table selectivity by sampling some probably very selective predicates

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • 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

          includes

          Task - A task that needs to be done. MDEV-4343 Find selectivity of conditions by reading N first rows of its table

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-4552 Testing for MDEV-4345 (sampling probably selective predicates)

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              sanja Oleksandr Byelkin
              sanja Oleksandr Byelkin
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.