Broadcast Join vs Sort Merge Join vs Shuffle Hash Join in Apache Spark

When working with large-scale data in Apache Spark, understanding join strategies is critical for performance tuning. Spark does not always execute joins the same way. Depending on dataset size and co