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

          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.