• Star join plan utilizes push-down hash join technology.

    星型连接计划利用下推散列连接技术

    zuci.chaziwang.com

  • It selects a hash join with PART as the inner table which runs in 299 seconds.

    选择一个散列连接PART作为内部这个计划只需运行299

    www.ibm.com

  • 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,这是一个相当大数字

    www.ibm.com

  • 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.

    连接计划指示强制优化器使用指定连接方法连接查询中的要么嵌套循环连接分类合并连接要么动态哈希连接

    www.ibm.com

  • The most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.

    常用连接方法就是嵌套循环连接分类合并连接动态哈希连接

    www.ibm.com

  • 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.

    利用下推连接技术星型连接计划使得散列连接更加有效主要原因是,初期减少事实(探测)的行数

    zuci.chaziwang.com

  • This query plan uses hash join for each join between the fact table and a dimension table.

    这个查询每个事实维度之间连接使用散列连接

    www.ibm.com

  • 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通过连接生成一个查找

    www.ibm.com

  • The optimizer will choose dynamic hash join if none of the joined columns has index.

    如果连接存在索引,那么优化器选择动态哈希连接

    www.ibm.com

  • The primary purpose of a push-down hash join is to reduce number of rows processed from the fact table, which probes each of the hash tables.

    下推连接主要目的减少处理事实行数这样可以探测每个列表

    www.ibm.com

  • This join method is replaced by dynamic hash join for IDS version 7 and above.

    IDS版本7以及更高版本中,连接方法动态哈希连接所取代

    www.ibm.com

  • The hash join in the access plan estimates that 1 row will be returned when in fact it is 4 rows.

    根据估计访问计划中的散列连接返回1,而实际上4

    www.ibm.com

  • As mentioned above, dynamic hash join is a new join method for IDS version 7 and above.

    正如上面所提到的,动态哈希连接IDS版本7以及更高版本中的连接方法

    www.ibm.com

  • The join between the fact table and any dimension table is an equi-join, which makes a hash join possible.

    事实任何维度之间连接等值连接使得连接成为可能

    www.ibm.com

  • It's a right-deep query plan such that for each hash join, the build table is a small dimension table.

    每个连接查询构建一个维度

    www.ibm.com

  • The larger the probe table is in a hash join, the slower the join is.

    散列连接中的探测越大连接

    www.ibm.com

  • 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).

    动态连接包含两个动作构建或者我们构建阶段),以及探测探测阶段)。

    www.ibm.com

  • 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

    www.ibm.com

  • 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_numorders . customer_num都没有被索引那么优化选择动态哈希连接来作为最佳执行计划

    www.ibm.com

  • A hash join method is requested to perform the join between the 'SECURITY' and the 'ORDER' tables.

    请求使用一个hash连接方法执行SECURITYORDER之间连接

    www.ibm.com

  • A hash join is usually faster than a sort merge join since there is no sort operation involved.

    连接通常分类合并连接因为没有涉及到分类操作

    www.ibm.com

  • How a standard hash-join plan works?

    标准列连接计划如何工作的

    www.ibm.com

  • First, use the db2set command to set DB2_HASH_JOIN to NO, and stop and start db2, as shown in Listing 1.

    首先,要使用db2set命令将DB2_HASH_JOIN设置NO,然后停止启动db2清单1

    www.ibm.com

  • In the EXPLAIN output, you will see something similar to the following (note that DB2_HASH_JOIN is disabled in this example).

    EXPLAIN输出可以看到类似下面的结果(注意禁用了DB2_HASH_JOIN)。

    www.ibm.com

  • 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.

    如果查询包含连接那么优化器就必须确定连接计划(hashsortmergenestedloop),以及评估连接次序

    www.ibm.com

  • When hash tables are built, join keys are pushed down and used to filter the rows of the fact table, and performance improves dramatically.

    构建列表连接用于过滤事实性能也显著提高

    www.ibm.com

  • After the first table has been scanned and placed in a hash table, the second table is scanned and each row in the table is looked up in the hash table to see if a join can be made.

    扫描第一将它放在之后扫描第二查找该表中的每一是否可以进行连接

    www.ibm.com

  • 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.

    MERGE SCAN连接操作(某些情况下)NESTEDLOOP可以通过同时执行连接操作分支分支而异步获益

    www.ibm.com

  • In a star join plan, the database server pushes down keys from a dimension table to filter the fact table at the same time as it builds the hash table on the dimension table.

    星型连接计划数据库服务器维度中构建列表同时维度中下过滤事实

    www.ibm.com

  • In a star join plan, the database server pushes down keys from a dimension table to filter the fact table at the same time as it builds the hash table on the dimension table.

    星型连接计划数据库服务器维度中构建列表同时维度中下过滤事实

    www.ibm.com

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定