Bigquery, Execution Plan, Query Optimization.
joined key before joining. This is to ensure all the join keys to end up in the same worker, thus the joins can be performed locally. However, if you join one very large table with a very small table, usually the small table won’t be shuffled. This is called a broadcast join. Such broadcasting of