what are the difference between view and materialized view?




Materialized views are schema objects that can be used to summarize, precompute, replicate,
and distribute data. E.g. to construct a data warehouse.
A materialized view provides indirect access to table data by storing the results of a query in a separate schema object. Unlike an ordinary view, which does not take up any storage space or contain any data

No comments:

Post a Comment