• About Oracle
  Fast refreshable materialized view errors, part seven: a summary
  in Oracle > DB 11g with errors materialized refreshable summary view
• Brief introduction into Materialized Views
  The Oracle Instructor Tune Materialized views
  in Oracle > PL/SQL 11g with 11g introduction materialized oracle teaching tuning views
• How to “MAX” out your Fast Refresh Materialized Views - Blue Gecko
  DBMS_ADVISOR.TUNE_MVIEW,
  in Oracle > DB 11g with dbms_advisor materialized max mv tune tune_mview view views
• Using Dbms_Advisor.Tune_Mview To Optimize Materialized Views For Fast Refresh (Doc ID 249993.1)
  Due to the restrictions on fast refresh, the original materialized view can only use fast refresh after inserts since there is no count(*) in the materialized view defining statement.
  in Oracle > DB 11g with count defining dml due error fast inserts materialized ora-32314 original refresh restrictions statement view
  Note: Restrictions of fast refresh of Materialized Views after DML.
• Using TUNE_MVIEW and EXPLAIN_REWRITE to enable us to tune MV Fast Refreshes and Query Rewrites
  Use 11g packages in DBMS_MVIEW to see how the SQL query transformed or rewritten to use materialized view instead
  in Oracle > Optimization with and dbms_mview explain_rewrite materialized mv tune_mview view views
• Materialized Views: ON COMMIT
  in Oracle with commit materialized oracle views

materialized from all users