QuestionQ42
VerifiedPreparing and using data for analysisYou have a query that filters a BigQuery table with a WHERE clause on timestamp and ID columns. By using bq query "-dry_run", you learn that the query causes a full table scan, although the timestamp and ID filters select only a tiny fraction of the total data. You want to reduce the amount of data BigQuery scans with minimal changes to the existing SQL queries. What should you do?
Community Discussion