11gR2 invalid materialized view refresh results with outer joins
Supposedly the bugs associated with these problems (6674549, 10092858) have been fixed in 11gR2, but I am still seeing issues with materialized view fast refresh correctness and performance when there are outer joins to two tables. In particular in 11gR2, I can create both materialized views that will include extra rows and materialized views that will do unnecessary full table scans when fast refreshed. These two cases generate different SQL statements during the refresh to insert into the materialized view. The incorrect insert does not check for the existence of rows that need to be updated. The slow insert forces full table