Optimization of partial merge join by squashing left-hand blocks to improve join performance and memory efficiency.
Why it matters
This feature enhances the partial merge join operation by combining multiple left-hand input blocks into fewer blocks, reducing overhead and resource consumption during query execution. It solves the problem of processing numerous small blocks which can degrade performance and increase memory usage, thus providing faster and more efficient join operations.How to use it
This optimization is applied internally within the partial merge join algorithm and does not require explicit user intervention or configuration. Users benefit from improved join performance automatically when running queries involving partial merge joins.