Bigquery, Execution Plan, Query Optimization.
the smaller input is often cheaper than re-distribution of both inputs https://www.querifylabs.com/author/vladimir-ozerov Window functions: Simply because it has a PARTITION BY, which works similarly as GROUP BY ❓ You might be wondering: so how about ORDER BY? Well ORDER BY doesn’t invoke shuffling