Example 5: INLIST to Nested Loop Join (query rewrite).
例子5：INLIST改为嵌套循环连接(查询重写)。
The output of our disconnected JoinRowSet object correctly parallels the data we obtained when we performed our server side database JOIN query (compare to Table 3).
非连接对象JoinRowSet的输出与我们在服务器端执行join查询得到的数据完全一致(与表3比较)。
Query after removing useless join operations.
删除无用的连接操作之后的查询。
Query 2 applies the join predicate to the authors table.
查询2对authors表应用连接谓词。
If specified, it can only take the value 'TRUE' to indicate that the given table must be the first table accessed in a join query.
如果指定了的话，它将只接受“TRUE”值，表示给定表必须是连接查询中进行访问的第一个表。
You can always convert a nested query into an equivalent join.
您始终可以将嵌套查询转换成等价的连接。
XPath doesn't provide a means to join XML nodes in a query.
XPath没有提供在查询中连接xml节点的方法。
To show how to interpret SET EXPLAIN output for star join plans, we use the same example query as before.
我们使用前面的同一个示例查询来说明如何解释星型连接计划的SETEXPLAIN输出。
You can define guidelines that influence only a few attributes of an execution plan, such as index specification for a certain table in the query or join order for a pair of tables.
可以定义那些只影响执行计划的某些属性的准则，比如查询中的某个表的索引说明，或者一对表的连接顺序。
The following query explicitly casts both sides of the join predicate to DOUBLE.
以下查询明确地将连接谓词的两端转换为DOUBLE。
Figure 4 shows a plan using the nested loop join operations at the federated server to evaluate this query.
图4展示了一个在联邦服务器使用嵌套循环连接操作符来计算这个查询的计划。
The optimizer would chalk out a query plan before performing the actual join operation itself by making use of the statistical data.
在执行实际的连接操作之前，优化器使用统计数据制定一个查询计划。
Using views in a SELECT statement can restrict the join order of the tables and limit the query optimizer's choices when considering access plans.
在select语句中使用视图，可以限制表的连接顺序，同时也限制查询优化器在考虑访问计划时的选择。
For example, the query in Listing 1 describes a join of the Dept and Employee tables.
举例来说，清单1中的查询描述了Dept和employee表的连接。
The optimizer calculates and compares the costs of each join method and selects the best one to use when evaluating query execution plans.
当评估查询执行计划时，优化器计算并比较每种连接方法的成本，然后选择要使用的最佳方法。
Ability to join, union, aggregate, and otherwise correlate data from multiple sources in a single query.
在一个查询中连接、联合、聚集来自多个数据源的数据并使它们相关的能力。
Joining the keys will never be true in this case, but is required since IBM Cognos BI requires at least one item per query subject to create a valid join.
本例中连接键不会为true，但却是必需的，因为IBMCognosBI要求每个查询主题至少要有一项，以创建有效连接。
Table and use an AS clause to name these columns for the display with the ij tool. Because the query joins these two tables (by using an implicit inner join), you can select columns from both tables.
因为查询(通过使用隐式内连接)将两个表连接，您可以从两个表中选择列。
Efficient structural join is the key operation in XML query processing.
有效的结构连接是XML查询处理的关键。
This query retrieves the desired author information, but it would not use either of the indexes for the join processing.
该查询检索了所需的作者信息，但是没有将索引用于连接处理。
In these cases you can query the object representing the advised join point for its associated annotations.
在这种情况下，可以查询表示已通知连接点的对象来获得相关的注释。
The optimization of SQL queries utilize sophisticated features, such as: query rewrite, multiple join methods, detailed statistics, parallelism etc.
SQL查询的优化利用了一些复杂的功能，例如：查询重写、多连接(join)方法、详细的统计、并行性等。
For your report, you need two query subjects in the Cognos project that you then join to obtain a textual description for each outlier.
对于这个报告，Cognos项目中需要两个查询主题，然后通过连接它们获得每个离群值的文本描述。
Structural join is the core operation in XML query processing, there have been a number of algorithms proposed for structural join, but all of them could not support query of multiple versions XML.
结构化连接是XML查询处理的核心操作，目前已经提出了许多结构化连接的算法，但都不支持多版本的XML文档。
A star join query typically involves a fact table and several dimension tables, with join predicates between the fact table and each dimension table.
一个星型连接查询通常包含一个事实表和几个维度表，事实表和每个维度表之间都有连接谓词。
The nested loop join method is used to join the remote query result from each warehouse and the XML composite view result.
这里使用了嵌套的循环连接方法来连接来自每个仓库的远程查询结果和xml合成视图结果。
If the query includes a join, the optimizer must determine the join plan (hash, sort merge, or nested loop), and the order in which tables are evaluated or joined.
如果该查询包含了连接，那么优化器就必须确定连接计划(hash、sortmerge或nestedloop)，以及评估或连接表的次序。
Multiway spatial join is the spatial join query which concern several spatial relations.
空间多路连接是涉及多个空间关系的连接查询。
As join operation to relational database, structural join order selection is at the heart of query optimization in an XML database.
和关系数据库中的连接运算一样，结构连接顺序的选择是XML数据库查询优化的核心。
Distance join is widely used in spatial database. Selectivity estimation for distance join is the basis of optimizing the query of the distance.
距离连接在空间数据库中有着广泛的应用，而距离连接的选择度估计是优化距离查询的基础。
应用推荐