Read-Only Materialized Views

In a basic configuration, materialized views can provide read-only access to the table data that originates from a master site. Applications can query data from read-only materialized views to avoid network access to the master, regardless of network availability. However, applications throughout the system must access data at the master site to perform data manipulation language changes (DML). The masters of read-only materialized views do not need to belong to a replication group.

Read-only materialized views provide the following benefits:

• Eliminate the possibility of conflicts because they cannot be updated.

• Support complex materialized views. Examples of complex materialized views are materialized views that contain set operations or a CONNECT BY clause.