Bigquery, Execution Plan, Query Optimization.
query processing (BigQuery doc) Use LIMIT clause. Usually LIMIT clause only helps reduce data written to the last shuffler layer before query results are returned to the Console. Exception is when it’s used in conjunction with ORDER BY clause as I explained earlier. Reduce redistribution at shuffle