[BillinghamJ]

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-in...

[beckingz]

These are unfortunately limited to a tiny subset of SQL.