|
What is Materialized view? What is a snapshot?A materialized view is a database object that contains the results of a query. A snapshot is similar to materialized view but has lesser features than a materialized view. Like a snapshot, a materialized view creates a local table to store the data and the views that accesses that data. Unlike snapshots, materialized views can be dynamically used by the optimizer to change the execution paths for queries, also known as query rewrite. Reason that Snapshot exists even when materialized view has all its features is that, snapshots are used for backward compatibility.
|
