Bigquery, Execution Plan, Query Optimization.
when specifying a subquery in the WHERE clause, in order to evaluate unique field values only once. Avoid SELF JOINS & CROSS JOINS Reduce the amount of processing tasks at each stage Do not repeat same transformation twice. Avoid WET (write-everything-twice) code, aim for DRY