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

Fix table selectivity by sampling some probably very selective predicates

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

            pushed to lp:~maria-captains/maria/maria-10.0-mwl253

            sanja Oleksandr Byelkin added a comment - pushed to lp:~maria-captains/maria/maria-10.0-mwl253

            It was implemented in 10.0.3 (cannot set the 'Fix version' field because 10.0.3 is archived).

            elenst Elena Stepanova added a comment - It was implemented in 10.0.3 (cannot set the 'Fix version' field because 10.0.3 is archived).

            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.