Bigquery, Execution Plan, Query Optimization.
queries: Partition large & commonly-used tables Filter partitioned tables as early as possible in your queries This will save the leaf node from a full scan of the source table when it tries to retrieve data from Colossus storage to the shuffle layer Reduce the amount of data written to and from