Bigquery, Execution Plan, Query Optimization.
layer From the previous section you already know GROUP BY, DISTINCT, JOIN & Window functions are expensive and often cause serious bottleneck in your distributed SQL queries. Therefore, only use them when you absolutely have to When you have no other choice but to use GROUP BY, DISTINCT, JOIN &