[PHOENIX-4599] Push LIMIT down to sort-merge-join's preserved side

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Wei Xue
• Reporter: Wei Xue
• Created: 12/Feb/18 21:32
• Updated: 12/Feb/18 21:32

Description

In OUTER sort-merge-joins, LIMIT being pushed down to one/both of its child plans will lead to less bytes being scanned or sorted and can have a significant performance impact.