Question: what is the difference between fast refresh and complete refresh in materialized view?
Answer: "Complete Refresh" means you truncate entire materialized view and insert new data. "Fast Refresh" means you update (or insert/delete) only the rows which have been changed on master tables. Usually Fast Refresh is much faster than Complete Refresh but it has restrictions.