Member-only story
Featured
Google made Smart Tuning for Materialized Views available
Tuning Query Performance when working with Materialized Views
Google announced that you can now use smart tuning for materialized views — this can improve query performance.
In BigQuery materialized views are pre-computed views that cache the results of a query periodically. You can use that feature to improve performance and efficiency. BigQuery uses pre-computed results from materialized views and, when possible, reads only delta changes from the base table to compute actual results. Materialized views can be queried directly or used by BigQuery Optimization to process queries to the base tables.
Queries that use materialized views are typically faster and consume fewer resources than queries that retrieve the same data exclusively from the base table. Materialized views can significantly improve the performance of workloads that have frequent and repetitive queries[1].
Google now stated that smart tuning is now supported for materialized views when they are in the…
