HF RL Explorer

Slow hash joins on SYMBOL columns – extend integer key comparison optimization

Slow hash joins on SYMBOL columns – extend integer key comparison optimization: a task in LegoFlow-SWE (Harbor dataset). When a hash join is performed on one or more SYMBOL columns, the join key comparison currently works by comparing the string values of the symbols. This is much slower than…

The task

When a hash join is performed on one or more **SYMBOL** columns, the join key comparison currently works by comparing the string values of the symbols. This is much slower than comparing their integer symbol IDs, particularly for large tables. The same integer‑based key comparison optimisation already exists for…

Part of Lego-X/LegoFlow-SWE.