# Broadcast hash join

Glossary, read 10 Nov 2026

**The short answer.** A broadcast hash join copies a small table to every executor and joins it against the large table in place, so the large side is never shuffled. Spark broadcasts a table automatically when it is under spark.sql.autoBroadcastJoinThreshold, which defaults to 10485760 bytes (10 MB) and is switched off with -1.

Because no shuffle is needed for the big side, this usually costs less than a shuffled join. It fails when the small side is not small, since every executor must hold a full copy in memory.

You can force it with the BROADCAST join hint. AQE can also pick it at runtime when a table turns out smaller than the planner estimated.

## A sourced example

With the default 10 MB threshold, a 40 MB dimension table is not broadcast automatically. Raising spark.sql.autoBroadcastJoinThreshold above 41943040 bytes, or adding a BROADCAST hint, changes the plan without touching the join logic.

## Sources

- Apache Spark documentation: SQL performance tuning, join strategy: https://spark.apache.org/docs/latest/sql-performance-tuning.html (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://sparkaccelerationcompare.com/glossary/broadcast-hash-join/
