Skip to content
Hacker News · AI·· 24 min agoAI score22

BigQuery Query Optimization: Myths vs. What Actually Saves Money

BigQuery Query Optimization: Myths vs. What Saves Money

AI summary

A BigQuery practitioner argues that standard query optimization checklists often fail to cut billed costs, because savings depend on the pricing model and on five layers: predicates, scope, engine, precompute and storage. On-demand bills bytes scanned while capacity bills slot time, so trimming bytes may not reduce slot consumption. Inner layers such as partitioning and clustering cap what outer SQL tweaks can achieve.

Source:Hacker News · AI · alvin.ai