Bigquery, Execution Plan, Query Optimization.
tables. If you have a CTE, join or subquery that is used multiple times in a query, think about materialize it in the persistent storage layer to reduce workload on the shuffle persistence layer. The small cost of storing the materialized data outweighs the performance impact of repeated I/O and