Details

    • Type: Technical task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 10.5
    • 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:
              1 Start watching this issue

              Dates

              • Created:
                Updated: