Bigquery, Execution Plan, Query Optimization.
read, compute & write a considerable amount of data pointlessly. Push complex operations, such as ORDER BY, regular expressions to the end of the query. This reduces the data to be processed before the complex operations are performed Consider materializing repetitive CTEs, joins and subqueries as