Bigquery, Execution Plan, Query Optimization.
(do-not-repeat-yourself) code. Example of using Execution Plan to optimize query WITH users_posts AS ( SELECT * FROM `bigquery-public-data`.stackoverflow.comments AS c JOIN `bigquery-public-data`.stackoverflow.users AS u ON c.user_id = u.id ) SELECT user_id, ANY_VALUE(display_name) AS display_name,