BigQuery's new Advanced Runtime automatically improves query performance by up to 30% through enhanced vectorization without requiring code changes. Testing with TPC-H dataset showed runtime reduction from 398s to 280s and 32% decrease in slot consumption, translating to significant cost savings for slot-based pricing models.
Table of contents
New RuntimeUnderstanding BigQuery enhanced vectorization | Google Cloud BlogEnabling Advanced RuntimeTest SetupBigQuery Pricing — Three Best PracticesGet Justin Taras’s stories in your inboxThe Baseline TestAdvanced Runtime TestWhat if I use the On-Demand Pricing Model?Disabling the Advanced RuntimeConcluding ThoughtsUse the BigQuery advanced runtime | Google CloudSort: