Bigquery, Execution Plan, Query Optimization.
Window functions, try to reduce the data before as much as possible by performing aggregation earlier in the query. Avoid Skewed JOIN. You already know the concept of shuffling in BigQuery. When it performs a JOIN function, it redistributes data from input tables into different buckets based on the