hash join发音

意思翻译

散列连接

相似词语短语

hash───n.剁碎的食物；混杂，拼凑；重新表述；vt.搞糟，把…弄乱；切细；推敲；n.(Hash)人名；(阿拉伯、保、英)哈什；(西)阿什

join───n.(Join)人名；(法)茹安；vt.参加；结合；连接；vi.加入；参加；结合；n.结合；连接；接合点

hash total───数字总和；数位总和

hash browns───薯饼，洋葱土豆煎饼

hash decoder───哈希解码器

join force───合力；共同合作；加入

hash symbol───哈希符(号)；n.哈希符（号），井字符（号）

sardine hash───沙丁鱼杂烩

hash mark───n.为识别服役年资而缝在制服左袖上的斜条

双语使用场景

It selects a hash join with PART as the inner table which runs in 299 seconds.───它选择一个散列连接，以PART作为内部表，这个计划只需运行299秒。

Star join plan utilizes push-down hash join technology.───星型连接计划利用下推散列连接技术。

This join method is replaced by dynamic hash join 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 join between the fact table and any dimension table is an equi-join, which makes a hash join possible.───事实表和任何维度表之间的连接都是等值连接，这使得散列连接成为可能。

A hash join is usually faster than a sort merge join since there is no sort operation involved.───哈希连接通常比分类合并连接快，因为它没有涉及到分类操作。

The optimizer will choose dynamic hash join if none of the joined columns has index.───如果连接列上不存在索引，那么优化器将选择动态哈希连接。

However, hash join operations are often much faster if the two input sizes differ significantly from each other.───但是，如果这两个输入的大小相差很大，则哈希联接操作通常快得多。

A hash join method is requested to perform the join between the 'SECURITY' and the 'ORDER' tables.───请求使用一个hash连接方法来执行“SECURITY”和“ORDER”表之间的连接。

英语使用场景

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.

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

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

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.

Star join plan utilizes push-down hash join technology.

IBM Informix Server V11.70 introduces star join optimization that utilizes push-down hash join technology to improve query performance for decision support queries on star and snowflake schemas.