操作完成之后，关闭查询表测试窗口。
请参阅关于物化查询表的小节。
这种物化查询表中的数据是由用户维护的。
The data in this type of materialized query table is maintained by the user.
这种物化查询表中的数据是由系统维护的。
The data in this type of materialized query table is maintained by the system.
定义补充表和查询表属性。
为了支持这样的场景，现在可以创建查询表。
下一步是定义查询表。
使用查询表添加元数据
HTM为此提供两个内置特性：定制的属性和查询表。
HTM offers two built-in features to this end: custom properties and query tables.
然后，管理员把查询表定义部署到服务器上。
The administrator then deploys the query table definition onto the server.
另一种方法是使用查询表策略，这依赖于编码表。
An alternative approach is to use a lookup table strategy that relies on code tables.
这里会生成一条sql语句，用于查询表中被选中的列。
A SQL statement is generated for querying the selected columns in the table.
查询表定义已经创建了，在本文的项目交换文件中提供。
The query table definitions have been created already and are part of the project interchange file provided by this article.
通过查询emp物化查询表发现，它现在已经填入了数据。
A query executed against the EMP materialized query table shows that it is now fully populated with data.
首先创建一个补充查询表，供随后创建的复杂查询表引用。
A supplemental query table is created first, and is referenced by the composite query tables created thereafter.
例如，屏幕标签查询表的XML文件的格式可能像下面这样。
For example, the format of an XML file of screen labels lookup table might be the following.
不支持范围簇表（RCT）、物化查询表（MQT）和有类型的表。
Not supported are range clustered tables (RCT), materialized query tables (MQT), and typed tables.
物化查询表可以显著提高查询的性能，尤其是提高复杂查询的性能。
Materialized query tables can significantly improve the performance of queries, especially complex queries.
当两个项目之间需要关系映射时，这个特性主要用作一个查询表。
This feature is mainly used as a look up table when relationship mapping is needed between 2 items.
通过验证控制台中的成功消息，确认3个查询表已经全部成功部署到服务器。
Ensure that all three the query tables have successfully been deployed to the server by verifying the success message in the console.
另外，支持基于查询表的属性、多次出现的属性、属性组和关系属性。
Furthermore, support for lookup table-based attributes, multi-occurrence attributes, attribute groups, and relationship attributes comes out of the box.
注册表的值又确定在查询优化期间将使用何种类型的刷新延迟物化查询表。
The value of the register in turn determines what types of refresh deferred materialized query tables will be used during query optimization.
包含在物化查询表中的数据来自定义物化查询表时所基于的一个或多个表。
The data that is contained in an MQT is derived from one or more tables on which the materialized query table definition is based.
例如，可以添加一个查询表，把每个州和州的两位数字ZIP代码关联起来。
For example, you might add a new lookup table associating each state and its two-digit ZIP code.
开发人员可以使用QueryTableBuilder工具创建查询表定义。
A developer can create a query table definition using the query table Builder tool.
要改进性能，联合需要经常使用缓存、物理查询表(MQT)以及分布式查询优化和执行。
To improve performance, federation frequently USES caching, materialized query tables (MQTs), and distributed query optimization and execution.
OLTP查询中很少需要选择查找表作为需要相关表上的索引来支持联接的主查询表。
It is rare in an OLTP query for the lookup tables to be selected as the primary query tables requiring an index on the dependent table to support the join.
AdvancedDBA考试涉及到联邦数据库、分区、具体化的查询表和多维集群表。
The Advanced DBA exam gets into federated databases, partitioning, materialized query tables, and multidimensional clustering tables.
物理数据库设计包括表设计、索引设计、物化查询表设计，以及其他物理数据库对象的设计。
Physical database design includes table design, index design, materialized query table design, and the design of the other physical database objects.
该值应该是一个字符串，在查询表时，希望将该字符串添加到where子句的后面。
The value should be a string that you want to be added to the end of the where-clause when querying the table.
应用推荐