Materialized Views
The two types of views that we have seen thus far, inline view and database view, create a virtual table at runtime. This means the view must execute the SELECT statement at the time it is used. A benefit of this is that the derived records do not have to be stored on the database. The problem with complex views is in the time needed to derive the records. Complex queries (or views) can take minutes or longer to derive the result set.
Oracle has a third type of view that has physical properties: a materialized view. Materialized views or snapshots are used to replicate data. This can be at a remote site for query performance or in a local data warehouse. The beauty of materialized views is the available options. Materialized ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
