The data in this type of materialized query table is maintained by the user.
这种物化查询表中的数据是由用户维护的。
A query executed against the EMP materialized query table shows that it is now fully populated with data.
通过查询emp物化查询表发现,它现在已经填入了数据。
The data that is contained in an MQT is derived from one or more tables on which the materialized query table definition is based.
包含在物化查询表中的数据来自定义物化查询表时所基于的一个或多个表。
If a query has a function template in a predicate or a select list, the function template must be part of the materialized query table.
如果查询在谓词或选择列表中具有一个函数模板,那么该函数模板必须是物化查询表的一部分。
Another way to provide a new and better access path for a query is through the use of DB2's materialized query table (MQT) functionality.
为查询提供更好的访问路径的另一种方法是使用DB2的物化查询表(MQT)功能。
Physical database design includes table design, index design, materialized query table design, and the design of the other physical database objects.
物理数据库设计包括表设计、索引设计、物化查询表设计,以及其他物理数据库对象的设计。
The statistical view is kind of like the Materialized Query Table (MQT), except that there is no need for materialization.
统计视图有点类似于物化查询表(Materialized Query Table,MQT),不同的是统计视图不需要物化。
The statistical view is kind of like the Materialized Query Table (MQT), except that there is no need for materialization.
统计视图有点类似于物化查询表(Materialized Query Table,MQT),不同的是统计视图不需要物化。
应用推荐