Use indexes for XML join predicates.
使用适于XML连接谓词的索引。
The three tables are joined with equal join predicates.
三个表用等值连接谓词连接。
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 example, write indexable or stage 1 predicates and avoid writing queries without join predicates (also known as Cartesian join).
例如,编写可索引或一阶谓词,尽量不要编写没有连接谓词(也称为Cartesian 连接)的查询。
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.
这些附加的源列,加上用户查询中附加的源连接谓词,可以帮助重写阶段识别不会产生任何连接结果的连接。
Join predicates with in or or operators.
带有IN或OR操作符的连接谓词。
Join predicates need to be specified in the FROM clause.
需要在from子句中指定联结谓词。
Join predicates need to be created out of each of the joins.
需要为每个联结创建联结谓词。
Join predicates need to be created out of each of the joins.
需要为每个联结创建联结谓词。
应用推荐