4 ms·
Admittedly not an application database, but BigQuery also has materialized views that never return stale data It also rewrites queries to make use of any mater
by BillinghamJ 4y ago
Admittedly not an application database, but BigQuery also has materialized views that never return stale data
It also rewrites queries to make use of any materialized views you have, if it would make the query more efficient without affecting the results (so covers some use cases which indices would cover)
https://cloud.google.com/bigquery/docs/materialized-views-intro https://cloud.google.com/bigquery/docs/materialized-views-in...
- beckingz 4y agoThese are unfortunately limited to a tiny subset of SQL.