Materialized View

Materialized Views

-----------------------------------------------------------------------------------------------------------------------

Advantages:

1. Data replication from one site to many sub sites faster.
2. Avoid network loads to master site.
3. Improve performance of any complex sql.

Types:

1. Read only.
2. Updatable ( user can make change to local mview and can be sent back to master mview).( MV group requried ).
3. Writable ( user make change to local mview but when refreshed it can not sent back to master mview).


1. Primary Key MV.
2. Object type MV.
3. Complex MV.

Refresh Methods:

An MV can be refresh by itself using the any of the following methods.

1. Complete.
2. Fast. ( a log requried ).