hard20 pts · first answer countsperformancecost-optimization

Cutting warehouse scan cost

A BigQuery table of 20 TB is partitioned by date. Most queries filter on one day and a tenant_id, but they still scan the whole day (about 50 GB). What is the most effective next step?

A.Add LIMIT 100 to every queryB.Partition the table by tenant_id instead of dateC.Use SELECT * so the cache is used moreD.Cluster the table by tenant_id so blocks for other tenants can be skipped within each partition

← Applying CDC events Upstream renamed a column →