Details
-
Technical task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
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:
- Cost of sorting to be added to the trace when we consider the ORDER BY LIMIT optimzation
- Whenever limit is applied to the record count of the partial join order, print the new partial record count to the trace
- All the plans that considered using a sort-nest [DONE]
- Tables inside the sort-nest [DONE]