You create a regular (non-materialized) view with an aggregation. A user runs SELECT * FROM the view 100 times in a session. What happens regarding the underlying computation?
CREATE VIEW daily_totals AS
SELECT day, SUM(amount) AS total
FROM sales GROUP BY day;