complete refresh

What Is Fast Refresh In Materialized View? A fast refresh requires having a materialized view log on the source tables that keeps track of all changes since the last refresh, so any new refresh only has changed (updated, new, deleted) data applied to the MV. A complete refresh does what it says: it completely refreshes

What Does Dbms_mview Refresh Do? DBMS_MVIEW. REFRESH: Refreshes one or more Oracle materialized views How do materialized views get refreshed? Materialized views can be refreshed in two ways: fast or complete. A fast refresh requires having a materialized view log on the source tables that keeps track of all changes since the last refresh, so