The value of the register in turn determines what types of refresh deferred materialized query tables will be used during query optimization.
注册表的值又确定在查询优化期间将使用何种类型的刷新延迟物化查询表。
Listing 2 shows an example of creating a REFRESH DEFERRED user-maintained MQT.
清单2展示了一个创建REFRESH DEFERRED类型的用户维护的MQT的例子。
The refresh DEFERRED clause means that the data in the table can be refreshed at any time using the refresh table statement.
REFRESH deferred子句的意思是，在任何时候都可以用REFRESHtable语句刷新该表中的数据。
Neither REFRESH DEFERRED nor REFRESH IMMEDIATE system-maintained MQTs allow insert, update, or delete operations to be executed against them.
不管是REFRESH DEFERRED还是REFRESHimmediate类型的系统维护的MQT，对它们的insert、update或delete操作都是不允许的。
While this example USES Immediate refresh, deferred refresh MQTs are generally more compatible with ETL activity.
虽然这个例子使用立即(Immediate)刷新，但推迟刷新的MQT通常更适合ETL活动。
While this example USES Immediate refresh, deferred refresh MQTs are generally more compatible with ETL activity.
虽然这个例子使用立即(Immediate)刷新，但推迟刷新的MQT通常更适合ETL活动。
应用推荐