What is the difference between force and complete refreshes in Materialized Views
CREATE MATERIALIZED VIEW MV1 REFRESH FORCE ON DEMAND AS SELECT * FROM T1; CREATE MATERIALIZED VIEW MV1 REFRESH COMPLETE ON DEMAND AS SELECT * FROM T1; CREATE MATERIALIZED VIEW MV1 REFRESH ON DEMAND AS SELECT * FROM T1; Need Just a brief difference between these statements?
Refreshes by recalculating the materialized view's defining query.
Applies incremental changes to refresh the materialized view using the information logged in the materialized view logs, or from a SQL*Loader direct-path or a partition maintenance operation.
Applies FAST refresh if possible; otherwise, it applies COMPLETE refresh.
Indicates that the materialized view will not be refreshed with refresh mechanisms.
The docs are the best available reference!!
