例子5：INLIST改为嵌套循环连接(查询重写)。
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。
This is a lot faster than a nested loop join of two table scans without any index usage.
如果满足下列条件，优化器将选择嵌套循环连接。
图4展示了一个在联邦服务器使用嵌套循环连接操作符来计算这个查询的计划。
Figure 4 shows a plan using the nested loop join operations at the federated server to evaluate this query.
最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。
The most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.
这里使用了嵌套的循环连接方法来连接来自每个仓库的远程查询结果和xml合成视图结果。
The nested loop join method is used to join the remote query result from each warehouse and the XML composite view result.
通过制定侦测以太网中路由循环、清除死循环连接的网络传输协议，交换机的死循环问题总算是解决了。
This problem was solved (for switches) by creating a protocol that detects loops in an Ethernet network and prunes connections until the loops are gone.
以上示例展示了如何使用连续扫描和索引来进行数据检索，以及如何使用嵌套循环连接方法来连接所有表。
The above example shows that sequential scan and indexes are used to do the data retrieval, and the nested-loop join method is used to join all tables.
其中有一个insert（步骤5）与索引扫描（步骤7）之间的嵌套循环连接（NLJOIN，步骤4 ）。
There is a nested loop join (NLJOIN, step 4) of the insert (step 5) to an index scan (IXSCAN, step 7).
连接计划指示，强制优化器使用指定的连接方法来连接查询中的表，要么是嵌套循环连接、分类合并连接，要么是动态哈希连接。
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.
烟气首先进入上述洗涤吸收组件，然后进入较低海拔高度设置的洗涤吸收液储存循环组件，后者与上述洗涤吸收组件实现循环连接。
Smoke goes into the above cleaning absorbing component, then the cleaning absorbing circulation component of lower latitude, with the latter connected to the said cleaning absorbing component.
如图19所示，在将任务移动到循环中时，它们之间的连接得到保持。
As Figure 19 shows, connections between tasks are maintained when they are moved into the loop.
这个循环会不断重复，并随着单断和重整连接以发出边界网关协议更新信息波至互联网的每一台路由器。
This cycle would repeat, with the single breaking and reforming link sending out waves of BGP updates to every router on the Internet.
通常，连接至因特网的大多数机器中有两个连接：到其自身的本地循环和到其本地服务供应商的连接。
Typically, most machines connected to the Internet have two connections: a local loop to themselves and a connection to their local service provider.
要正确捕获循环流程，请在流程模型中添加连接上游活动的逆向连接。
To correctly capture cyclic processes, add backward connections to the process model that connect to an upstream activity.
关键在于循环和网络套接字需要大量管理代码，这样才能监听、更新和控制不同的连接和接口。
The key is that the loop and network sockets need a lot of management code to ensure that you are listening, updating, and controlling the different connections and interfaces.
所有我们开启的循环的结束，关闭和远程服务器的SFTP连接和SSH会话。
End all of the loops we've opened, closing our SFTP connection and our SSH session on the remote server.
如果使用向后流向的连接而不是循环，则模拟可以正确运行，但无法将流程导出到WS - BPEL。
If you use a connection that flows backwards instead of a loop the simulation runs correctly, but you cannot export the process to WS-BPEL.
在喷管前有一组涡轮，涡轮与风扇连接在一根轴上。涡轮带动风扇又吸入了更多的空气，这样就产生了连续的循环。
On the way out, these gases drive a turbine which is connected to the fan via a shaft, thus drawing in more air and keeping the process going.
另外，请避免使用硬连接的流循环。
经历过肝脏胆管连接肠循环手术的患者具有更大的风险使得消融治疗后并发肝脓肿。
Patients who have had a surgical procedure in which the liver bile duct has been connected to a loop of bowel are at much greater risk of developing a liver abscess after ablation.
连接到该服务器的客户机如果只是间歇地需要新数字，而不需要尽快地得到新数字的话，那么它应该在其循环中使用time . sleep 。
The client that connects to this server should use a time.sleep in its loop if it only wants a new number intermittently rather than as fast as possible.
这个方法对样例应用程序完成所有的工作；它执行了一些设置(打开ServerSocket)，然后启动一个循环来接受进入的连接。
This is the method that does all the work for the sample application; it does some setup (opens ServerSocket), then starts a loop to accept the incoming connections.
相反，程序进入一个while循环，等待新的连接。
Instead, the program enters a while loop waiting for new connections.
清单4中显示的MessageServer run方法建立了一个无限循环以等待客户机连接。
The MessageServer run method, shown in Listing 4, establishes an infinite loop to wait for a client connection.
ProcessServerV6.1.2引入了一个称为循环流的新功能，其中任务之间的连接可以在流程中向后流动。
Process Server V6.1.2 introduced a new feature called cyclic flows, in which the connections between tasks could flow backwards in the process.
在第一个循环中，有一个逆向连接从decision开始并引回位于开始节点之后的 join。
The first cycle involves a backward connection that starts in the decision and leads back to the join following the start node.
结束if语句、文件循环、SFTP连接和SSH会话。
Close the if statement, file loop, SFTP connection, and SSH session.
最后，所有行连接成现在的HTML，当for循环完成后，就有了完整列表。
Finally, the whole line is concatenated to the existing HTML so you have a complete list when the for loop is completed.
inclusive decision 最上方的分支使用fork 之前的merge连接到第三个循环流程片断。
The upper branch of the inclusive decision connects to a third cyclic process fragment with a merge preceding a fork.
应用推荐