Refresh Mode/Method Recommendations

Refer to the following recommendations for determining the appropriate refresh mode/method:

  • If requirements are for a materialized view with stale data, use an On Demand/Complete refresh.

  • If requirements are for a materialized view with fresh data and the base tables are lookup tables, then use an On Commit/Fast refresh.

  • If requirements are for a materialized view with fresh data and the base tables are not highly transactional, then use an On Commit/Fast refresh.

  • If requirements are for a materialized view with fresh data and the base tables are highly transactional, then use an On Demand/Fast refresh.

This graphic provides a flowchart for determining the optimal refresh mode/method.

Flowchart for determining best refresh mode/method for materialized views