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

    • Task
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Optimizer
    • 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

        Issue Links

          Activity

            People

              igor Igor Babaev
              igor Igor Babaev
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.