3 ms·
Materialized views are great, but it is just a denormalized form with in-database updating instructions.
by earthboundkid 7y ago
Materialized views are great, but it is just a denormalized form with in-database updating instructions.
- deleted 7y ago[deleted]
- goto11 7y agoI prefer to think of it as a cached query result. Normalization is not compromised since there is no way to introduce inconsistencies.
- earthboundkid 7y agoIf you do a non-atomic update like “add 10 to transactions total” where total is a materialized view, it could bite you, but yes, it is less likely.