Question : In a materialized view with refresh fast on commit i have the below query select pp.ROWID AS PP_ROWID,aup.rowid […]
Tag: fast-refresh
Materialized view log not updating
Question : Under what conditions would a materialized view log not update? I must be missing something. I’ve got a […]
Immediate refresh materialized views (MQT) with OUTER JOIN under DB2
Question : DB2 accepts a materialized view based on an “OUTER JOIN” query, as long it doesn’t refresh automatically (REFRESH […]