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

Improve the cost model for usage of in-memory range rowid / primary key filters

    XMLWordPrintable

    Details

    • Type: Task
    • Status: In Progress (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: 10.9
    • Component/s: Optimizer
    • Labels:
      None

      Description

      The current implementation of range rowid filters introduced in 10.4 (see MDEV-16188) used a quite simplistic cost model. In particular the cost of index only access was not taken into account properly. This task intends to remove all defects of the current implementation due to improper estimation of the gain promising by usage of rowid range filter. The full new cost model for usage of range rowid filters will be presented in the comments below.

        Attachments

          Activity

            People

            Assignee:
            igor Igor Babaev
            Reporter:
            igor Igor Babaev
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.