hash join的意思

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.