O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required