Listing 2 shows an example of creating a REFRESH DEFERRED user-maintained MQT.
清单2展示了一个创建REFRESH DEFERRED类型的用户维护的MQT的例子。
The 'REFRESH DEFERRED' clause indicates that use of a 'REFRESH' statement will populate the MQT with data.
'REFRESH DEFERRED '子句指出，使用' REFRESH '语句将用数据填充m QT。
Since you can only create 'refresh deferred' MQTs on nicknames, you need to invoke the advisor with the '-u' option.
由于只能在昵称上创建'refresh deferred 'MQT，您需要带'- u '选项调用Design Advisor。
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语句刷新该表中的数据。
The value of the register in turn determines what types of refresh deferred materialized query tables will be used during query optimization.
注册表的值又确定在查询优化期间将使用何种类型的刷新延迟物化查询表。
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操作都是不允许的。
Both the parameters start out with a default value of 0, for instance, by default 'REFRESH DEFERRED' MQTs are not considered for optimization.
两种参数都以默认值0开始，例如，默认情况下不为优化考虑'REFRESH DEFERRED 'MQT。
Setting the current refresh AGE special register to the value ANY enables all refresh deferred MQTs to be considered for optimization in the context of the current connection.
将CURRENTREFRESHAGE特殊注册表设置为值any使得在当前连接上下文中，将为优化考虑所有刷新延迟的MQT。
While this example USES Immediate refresh, deferred refresh MQTs are generally more compatible with ETL activity.
虽然这个例子使用立即(Immediate)刷新，但推迟刷新的MQT通常更适合ETL活动。
DEFERRED means that the data in the table can be refreshed at any time using the refresh table statement.
DEFERRED的意思是，表中的数据可以在任何时候通过REFRESHtable语句来刷新。
In the case of refresh-deferred MQTs, make sure that the special register CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION is set to a value that includes the category of your MQT.
对于刷新延迟的MQT，确保特殊注册表CURRENTMAINTAINED TABLETYPESFOROPTIMIZATION被设置为一个包含您的MQT种类的值。
In the case of refresh-deferred MQTs, make sure that the special register CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION is set to a value that includes the category of your MQT.
对于刷新延迟的MQT，确保特殊注册表CURRENTMAINTAINED TABLETYPESFOROPTIMIZATION被设置为一个包含您的MQT种类的值。
应用推荐