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.