[ https://issues.jboss.org/browse/TEIID-4626?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4626: ------------------------------------- [~shawkins] For this JIRA, how about, - Add another column to {{Status}} table called "RefreshType", with values "EAGER, LAZY". - Add an extension property on View to select the type of refresh. Default to "LAZY" - When "LoadMatView" procedure runs it sets the LoadNumber to 'n' on the materialized view. - When CDC event comes in, and processed through "UpdateMatview", this procedure will update the affected column's LoadNumber to -1, and this will also keep {{Status}} table's "Updated" column unmodified. - When TTL event occurs, if LAZY, "LoadMatView" procedure updates all the rows with LoadNumber -1. If EAGER, depending upon {{Status}} table's Updated column this will either run or do a SNAPSHOT re-load. What do you think, will this work? -- This message was sent by Atlassian JIRA (v7.2.3#72005)