A materialized view yana adana sakamakon buhatun a jiki (da aka yi lissafi gida), ba kamar daidai view (wanda ke aiki da buhawar sa sau-sau). Wannan yana sa karantawa ya zama sauri don buhawar mai tsada, sai da bayani ya zama kawai a daidai da refresh na ƙarshe — tsarin ajiya jiya a cikin gidan bayani.
Regular view da materialized view
sales_summary region, (amount) orders region;
MATERIALIZED sales_summary_mat
region, (amount) total orders region;
sales_summary_mat;
