Materialized views are a much more powerful tool when used on databases that properly support them. When I’ve used them the database has transparently handled

Materialized views are a much more powerful tool when used on databases that properly support them. When I’ve used them the database has transparently handled updating them efficiently as the source data changes.