View — query সংরক্ষণ করা

CREATE VIEW revenue_by_user AS
SELECT u.id, u.name, SUM(o.total) AS total_spent
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
GROUP BY u.id, u.name;

-- view থেকেই query
SELECT * FROM revenue_by_user WHERE total_spent > 5000;

CREATE MATERIALIZED VIEW sales_daily AS
SELECT created_at::date AS day, SUM(total) AS revenue
FROM orders GROUP BY day;

-- data বদলে গেলে manually refresh
REFRESH MATERIALIZED VIEW sales_daily;