This illustration shows a flowchart for performing a fast refresh:
- If the materialized view is updatable, push the materialized view deferred transaction queue to update the master table. This step can also be performed separately using the
DBMS_DEFER_SYS.PUSH
function.
- Use the materialized view log to identify changes made to the master table.
- Propogate identified changes to the materialized view.
- End fast refresh.
If the materialized view is not updatable, follow steps 2-4 above.