Bigquery, Execution Plan, Query Optimization.
input data to the leaf node (stage 0) Reduce the amount of data written to and from shuffle persistence layer between intermediate stages Reduce redistribution at shuffle layer Reduce the amount of processing tasks at each stage Reduce the amount of input data to the leaf node Prune partitioned