A materialized view nyimpen asile saka query kanthi fisik (precomputed), beda karo regular view (kang mbukak maneh queryé saben wektu). Iki ndadekake maca cepet kanggo query sing mahal, miturute data mung seger sumusuul kaya refresh pungkasan — mekanisme caching ing database.
Regular view lawan materialized view
sales_summary region, (amount) orders region;
MATERIALIZED sales_summary_mat
region, (amount) total orders region;
sales_summary_mat;
