Use indexes for XML join predicates.
使用适于XML连接谓词的索引。
Join predicates with in or or operators.
带有IN或OR操作符的连接谓词。
The three tables are joined with equal join predicates.
三个表用等值连接谓词连接。
Join predicates need to be specified in the FROM clause.
需要在from子句中指定联结谓词。
Join predicates need to be created out of each of the joins.
需要为每个联结创建联结谓词。
Missing join predicates, but only if a foreign key is defined.
丢失连接谓词，只在定义了外键的情况下。
A merge scan join always involves one or more Equal join predicates.
一个合并联接总是涉及一个或多个Equal联接谓词。
At OPERATORS (8) and (7), you are not applying any local or join predicates.
在OPERATORS(8)和(7)上没有任何局部或连接断言。
You need to design indexes to support efficient access with local predicates and join predicates.
您需要使用本地谓词和连接谓词设计索引，以支持高效访问。
SQL expressions will need to be created from these attributes to form the join predicates of the SQL statement.
需要从这些属性创建SQL表达式，从而形成sql语句的联结谓词。
The join objects from the dimensions, facts, and cube model are used to form the join predicates of the WHERE clause.
来自维、事实和多维数据集模型的联结对象用来形成where子句的联结谓词。
This USES the join predicates on the source columns, and the values assigned to them in the UNION ALL view definitions.
期间会使用源列上的连接谓词，以及在UNIONALL视图定义中赋给这些列的值。
The attributes on this side will need to be converted to SQL expressions to form the join predicates of the SQL statement.
这一边上的属性需要转换为SQL表达式，从而形成sql语句的联结谓词。
To summarize the advice for XML join queries, always cast join predicates to the type of the XML index that should be used.
总结一下关于XML连接查询的建议，通常将连接谓词转换为应使用的xml索引类型。
The Join object has left-side attributes and right-side attributes, which are compared to each other to form join predicates.
联结对象具有左属性和右属性，对这两个属性进行比较，从而形成联结谓词。
For table CUST_ORDER_HEADER, both of the existing indexes do not support the local and join predicates on the table, as shown below.
对于cust_order_header表，现有的索引表不支持表上的本地和连接谓词，如下所示。
Strictly speaking, DB2 9.7 does not necessarily require the use of fn: string anymore to enable VARCHAR indexes for join predicates.
严格来说，DB 2 9.7不一定要使用fn：string来为连接谓词启用varchar索引。
An example of such a "readability" order is mentioned in shop standard example 1 (code join predicates before local predicates).
这样的“可读性”顺序的一个例子已经在前面的实践标准1(联接谓词先于本地谓词)中提到。
For example, write indexable or stage 1 predicates and avoid writing queries without join predicates (also known as Cartesian join).
例如，编写可索引或一阶谓词，尽量不要编写没有连接谓词（也称为Cartesian 连接）的查询。
Each of the four predicates are also displayed on different lines, with the two local predicates displayed before the two join predicates.
个谓词中的每一个也显示在不同的行上，两个本地谓词在两个联接谓词之前显示。
Customize the formatting ordering of the predicates according to various criteria such as local predicates or join predicates, and table references.
根据各种标准，如本地谓词或连接谓词，以及表引用来定制谓词的格式化顺序。
A star join query typically involves a fact table and several dimension tables, with join predicates between the fact table and each dimension table.
一个星型连接查询通常包含一个事实表和几个维度表，事实表和每个维度表之间都有连接谓词。
Code join predicates first, followed by local predicates (predicates on a single table) in the same order as the named tables appear in the FROM clause.
首先编码联接谓词，然后是本地谓词(单个表上的谓词)，顺序与from子句中的已命名表的顺序相同。
These additional source columns, combined with additional source join predicates in user queries, help the rewrite phase identify joins that will not produce any join results.
这些附加的源列，加上用户查询中附加的源连接谓词，可以帮助重写阶段识别不会产生任何连接结果的连接。
The result of the join and user predicates should be ANDed together in the form (joins) and (user predicates).
联结和用户谓词的结果应该以(联结)AND(用户谓词)的形式组合在一起。
As shown in Figure 13, the join and the local predicates are now above the nicknames.
如图13所示，连接和本地谓词现在在昵称之上。
What kinds of predicates are used to join the referenced tables?
使用了哪些种类谓词来连接引用表？
Query Q3 (5predsome) has multiple predicates and USES three side tables plus the main table, so it needs to compute a four-way join.
查询Q3 (5predsome)具有多个谓词、使用3个索引表和主表，因此它需要计算一个4路结合。
Listing 7 shows how to use a join with both relational and XML predicates and return, for each Purchase Order, the POID, and customer name.
清单7显示了如何使用关系和xml谓词合并J SONx，并为每个PurchaseOrder返回POID和客户名。
Predicates are reordered and regrouped based on the kind of predicate (local or join) and the table reference.
重新排序和重新组合谓词是基于谓词的种类(本地或联接)和表引用。
应用推荐