Example 7: Influencing Join Order 3, 4, 1, 2 (plan optimization).
例子7：影响连接顺序3、4、1、2(计划优化)。
Join order directives that force optimizer to join tables in the designated order.
连接次序指示，强制优化器按照指定次序连接表。
Thus, the way you write the XMLEXISTS predicate can affect the join order in these previous versions of DB2.
因此，编写xmlexists谓词的方式可以影响以前的DB 2版本连接顺序。
The optimizer can use its knowledge of the appliance components to determine the best join order in a complex join.
优化器可以利用其有关设备组件的知识，确定复杂联接操作中的最佳联接顺序。
Relational guidelines such as join, MSJOIN, NLJOIN, and HSJOIN can be used to specify the join order and the join type.
关系准则，比如join、MSJOIN、NLJOIN和HSJOIN都可以用来指定连接顺序和连接类型。
As join operation to relational database, structural join order selection is at the heart of query optimization in an XML database.
和关系数据库中的连接运算一样，结构连接顺序的选择是XML数据库查询优化的核心。
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, in debugging problems where you suspect the join order is not optimal, it can be useful to gather counts for different join combinations.
比方说，在调试怀疑连接顺序不是最优的问题时，针对不同的连接组合收集计数可能会有帮助。
Often the join order of a query will greatly determine the query execution performance, since it is more efficient to filter rows as early as possible.
通常，查询的连接顺序很大程度上决定了查询的执行性能，因为越早地过滤行，效率越高。
As part of the transformation, the optimizer also determines the correct table join order, rewrites expressions, and eliminates any redundancy from the SQL.
作为转换的一部分，优化器还决定正确的表联接顺序，重写表达式，并从SQL中消除任何冗余。
This paper presents a new de- sign for RFSS of multi - radiation centers, which bases on modifying feed circuits and the join order in traditional sys- tem.
通过改进原有馈电电路并调整开关矩阵与阵列天线的连接顺序，现提出了一套新型的多辐射中心仿真系统的设计方案。
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.
可以定义那些只影响执行计划的某些属性的准则，比如查询中的某个表的索引说明，或者一对表的连接顺序。
Our allies pressed us to join with them to act against the tyrant and restore order on the south shore of the Mediterranean.
我们的同盟们敦促我们加入他们来反抗暴君，并且重新恢复地中海南岸的秩序。
All of these methods require that you sincerely join the conversation in order to get the best results.
所有这些方法都要求你真诚地参与对话，以获得最佳结果。
We had previously thought that the market would return to some semblance of order and that our clients would not join in the panic.
它抱怨：“我们曾经以为市场可能回到某种表面的秩序，这样我们的客户可能就不会加入到恐慌的行列中。
Also, DB2 cannot use random order index columns as part of a sort merge join.
另外，DB 2无法在排序合并合并连接中使用随机顺序的索引列。
The new staff will also join teams visiting communities within the affected municipalities in order to improve public understanding of the disease and acceptance of control measures.
这些新的工作人员还将与受感染市内访问社区的小组相结合，以便改进公众对该病的了解和接受控制措施。
Don't yell or shout out loud. Always join a public queue for good order.
不喧哗吵闹，排队遵守秩序，不并行挡道，不在公众场所高声交谈。
We are asking these emerging partners to join us in shaping and participating in a rules-based regional and global order.
我们正邀请这些新伙伴与我们一起构建一套基于规则的区域及全球秩序并参与其中。
As shown in the IXSCAN descriptor in Figure 8, the leading column of the index exploited by optimizer is PRODUCT_NUMBER, which does not provide the order required for merge scan join.
如图8的IXSCAN描述符所示，通过优化器利用的索引的领先列是PRODUCT _ NUMBER，其不为合并扫描联接提供所需的顺序。
This provides the table a default order and a fast way to join the table against other tables.
这为表提供一个默认顺序和快速方式来联接其他表。
Therefore, a SORT node is also added to the outer of the join to enforce the order.
因此，也要添加sort节点到联接的外部来执行顺序。
A hash join method is requested to perform the join between the 'SECURITY' and the 'ORDER' tables.
请求使用一个hash连接方法来执行“SECURITY”和“ORDER”表之间的连接。
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)，以及评估或连接表的次序。
For the merge scan join to perform properly, both inputs are expected to be in the order of join columns.
为了合并扫描联接正确地执行，按照联接列的顺序预计有两个输入。
The optimizer considers star join optimization when appropriate and decides on star join plan based on cost considerations in order to come up with best execution plan for a star join query.
为了实现星型连接查询的最佳执行计划，优化器在适当的时候会考虑星型连接优化，并根据成本因素来决定星型连接计划。
He suggests making it easier to vote, in order to encourage more users to join in.
他建议简化投票方法，以鼓励更多的用户加入到其中来。
He smiled again and told us where to go, even what to order, apologizing because he could not leave his store long enough to join us.
他又一次向我们微笑，然后告诉我们该怎么走，甚至还告诉我们点什么菜，并因为他不能离开他的店铺太久去和我们一同品尝而表示歉意。
He smiled again and told us where to go, even what to order, apologizing because he could not leave his store long enough to join us.
他又一次向我们微笑，然后告诉我们该怎么走，甚至还告诉我们点什么菜，并因为他不能离开他的店铺太久去和我们一同品尝而表示歉意。
应用推荐