TLDR Tech / Data
Why Your Snowflake Joins Are Slow: Fix OR Joins Fast
Disjunctive joins (using OR in join conditions) break Snowflake's hash join optimization, forcing expensive Cartesian products and massive performance slowdowns. The fix is to rewrite them as separate equi-joins, restoring efficient execution and often delivering 100–200x speedups.
Read the full story