The larger the probe table is in a hash join, the slower the join is.
散列连接中的探测表越大，连接就越慢。
It selects a hash join with PART as the inner table which runs in 299 seconds.
它选择一个散列连接，以PART作为内部表，这个计划只需运行299秒。
This join method is replaced by dynamic hash join for IDS version 7 and above.
在IDS版本7以及更高版本中，该连接方法已被动态哈希连接所取代。
The optimizer will choose dynamic hash join if none of the joined columns has index.
如果连接列上不存在索引，那么优化器将选择动态哈希连接。
As mentioned above, dynamic hash join is a new join method for IDS version 7 and above.
正如上面所提到的，动态哈希连接是IDS版本7以及更高版本中的新连接方法。
This query plan uses hash join for each join between the fact table and a dimension table.
这个查询对每个事实表和维度表之间的连接使用散列连接。
The most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.
最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。
A hash join is usually faster than a sort merge join since there is no sort operation involved.
哈希连接通常比分类合并连接快，因为它没有涉及到分类操作。
The hash join in the access plan estimates that 1 row will be returned when in fact it is 4 rows.
根据估计，访问计划中的散列连接将返回1行，而实际上是4行。
A hash join method is requested to perform the join between the 'SECURITY' and the 'ORDER' tables.
请求使用一个hash连接方法来执行“SECURITY”和“ORDER”表之间的连接。
It's a right-deep query plan such that for each hash join, the build table is a small dimension table.
每个散列连接都是右深查询，构建的表是一个小的维度表。
The join between the fact table and any dimension table is an equi-join, which makes a hash join possible.
事实表和任何维度表之间的连接都是等值连接，这使得散列连接成为可能。
Note that the execution plan indicates that the left leg of each hash join will return about 800,000 rows, a significant number.
注意，执行计划表明，每个散列连接的左边分支将返回大约800,000行，这是一个相当大的数字。
The join is performed by scanning the inner table of the hash join, CUSTOMERS, and generating a lookup table by hashing the join column values.
该连接的执行过程包括扫描散列连接中的内表CUSTOMERS，并通过散列连接列的值生成一个查找表。
The dynamic hash join consists of two activities: building the hash (or build phase as we call it), and probing the hash table (or probe phase).
动态哈希连接包含两个动作：构建哈希（或者是我们所称的构建阶段），以及探测哈希表（或探测阶段）。
This is a hash join between the CUSTOMERS table, local to the federated server, and the BAD_CREDIT nickname that references a remote Oracle table.
这是表CUSTOMERS与昵称BAD_CREDIT之间的一个散列连接(hash join)，前者在联邦服务器本地，后者引用一个远程oracle表。
A star join plan utilizing push-down hash join technology makes hash joins more effective primarily due to reduction of fact table (probe table) rows early on.
利用下推连接技术的星型连接计划使得散列连接更加有效的主要原因是，在初期减少了事实表(探测表)的行数。
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.
连接计划指示，强制优化器使用指定的连接方法来连接查询中的表，要么是嵌套循环连接、分类合并连接，要么是动态哈希连接。
In the previous example, if customer.customer_num and orders.customer_num are not indexed, dynamic hash join would be chosen by the optimizer as the best execution plan.
在前一个实例中，如果customer . customer_num和orders . customer_num都没有被索引，那么优化器将选择动态哈希连接来作为最佳的执行计划。
In the previous example, if customer.customer_num and orders.customer_num are not indexed, dynamic hash join would be chosen by the optimizer as the best execution plan.
在前一个实例中，如果customer . customer_num和orders . customer_num都没有被索引，那么优化器将选择动态哈希连接来作为最佳的执行计划。
应用推荐