What is a Materialized View?
Materialized views are query results that have been stored or “materialized” in advance as schema objects. The FROM clause of the query can name tables, views, and materialized views. Collectively these objects are called primary tables (a replication term) or detail tables (a data warehousing term). Materialized views are used to summarize, compute, replicate, and … Read more