3 ms·
You can similarly use materialized views for this type of denormalization. When an update to the source tables occur you can trigger a view refresh.
by arrowleaf 2y ago
You can similarly use materialized views for this type of denormalization. When an update to the source tables occur you can trigger a view refresh.
- recroad 2y agoYes, very possible. This is a multi-tenant application so I don't want to trigger a view refresh so frequently as most updates don't affect most people.