Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8306 Complete cost-based optimization for ORDER BY with LIMIT
  3. MDEV-20503

Optimizer trace support for order by limit optimzation with sort-nest

    XMLWordPrintable

Details

    • Technical task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Optimizer
    • None

    Description

      For the order by limit optimization in MDEV-8306, we should add items regarding that optimization to the sort-nest

      The list is:

      1. Cost of sorting to be added to the trace when we consider the ORDER BY LIMIT optimzation
      2. Whenever limit is applied to the record count of the partial join order, print the new partial record count to the trace
      3. All the plans that considered using a sort-nest [DONE]
      4. Tables inside the sort-nest [DONE]

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            varun Varun Gupta (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.