Introduction to optimizing query performance

In general, queries that do less work perform better. When evaluating query performance in BigQuery, the amount of work required depends on a number of factors: