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

    • Type: Technical task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 10.6
    • Component/s: Optimizer
    • Labels:
      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

            Assignee:
            varun Varun Gupta
            Reporter:
            varun Varun Gupta
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: