Bigquery, Execution Plan, Query Optimization.
way that it minimizes disk seeks. (ref) Source: https://cloud.google.com/blog/products/bigquery/in-memory-query-execution-in-google-bigquery When shuffling happens? In BigQuery, as long as there are more than one worker, which happens 99.999%. of the time, there’s always some shuffling involved.