[QUICKSTEP-96] Fuse Selection into BuildHash

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Query Optimizer, Relational Operators
• Assignee: Unassigned
• Reporter: Zuyu Zhang
• Created: 20/Aug/17 21:08
• Updated: 20/Aug/17 21:09

Description

We may improve the hash join performance by avoiding intermediate materialization for a table scan on the stored build relation with predicates, if the SelectOperator is not used as repartition.

To this end, we may add an optimization rule on the physical plan, and we need to make sure it works with FilterJoin as well.