Join plan directives that force optimizer to use the designated join method to join tables in the query, either nested loop join, sort merge join, or dynamic hash join.
连接计划指示，强制优化器使用指定的连接方法来连接查询中的表，要么是嵌套循环连接、分类合并连接，要么是动态哈希连接。
I could have used a hash to optimize this loop further, but frankly I don't think it would have made a difference at all unless the user was finding hundreds of thousands of albums.
可以使用一个散列来进一步优化这个循环，但是坦白讲我并不认为这有多重要，除非用户要在无数的唱片中查找。
If TESTING is enabled, the hash entries are printed out in sorted order as the loop executes.
如果TESTING启用，当循环执行时，哈希条目将以排序顺序显示。
The most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.
最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。
Create a hash keyed on E-mail address for each state name, to be checked in the main program loop.
创建与每个州名的电子邮件地址绑定的散列，将在主程序循环中检查该散列。
Join operators such as HASH, MERGE SCAN and (in some situations) NESTED LOOP can also benefit from asynchrony by simultaneously executing the inner and outer legs of the join operator.
MERGESCAN等连接操作符和(在某些情况下)NESTEDLOOP也可以通过同时执行连接操作符的内分支和外分支而从异步中获益。
The inner foreach loop iterates over the hash entries and strips trailing space characters from the values.
内部foreach循环迭代哈希条目，删除值最后的后缀空格字符。
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)，以及评估或连接表的次序。
The for loop in Listing 7 translates their filename vagaries into simple X, Y (column and row) coordinates, and stores their values in the % vals hash.
清单7中的for循环将它们奇怪的文件名转换成简单的X,Y(列和行)坐标，并将它们的值存储在% vals散列中。
The first for loop searches for a pre-existing entry in the Windows hash that does not currently have a pipe attached to it.
第一个for循环将搜索目前没有绑定管道的窗口散列中的已有条目。
The first for loop searches for a pre-existing entry in the Windows hash that does not currently have a pipe attached to it.
第一个for循环将搜索目前没有绑定管道的窗口散列中的已有条目。
应用推荐