What is Materialized view?
A materialized view is a pre-computed dataset that is derived from query specification. Since the data is pre-computed, it becomes much easier to query the materialized view compared to a non-materialized view from the base table of the view. In plain language, materialized views are designed to improve the query performance of common and repetitive query models. Materialized views are the main database objects and accelerate projection, selection operations and expensive aggregation for queries that execute on larger datasets.
