Merge Sort Join的意思|示意

美 / / 英 / /

归并排序连接


Merge Sort Join的网络常见释义

合并排序连接 Oracle表联接操作——Merge Sort Join(合并排序连接) 就是可以一定程度上减少随机读的情况。合并排序连接的最大特征是在一次扫描的同时,就判断连接。

排序合并连接 嵌套循环连接(Nested Loop Join) 2. 排序合并连接(Merge Sort Join):PGA 中的 ..

Merge Sort Join相关短语

1、 sort-merge join 排序合并连接

Merge Sort Join相关例句

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

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

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.

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

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.

如果该查询包含了连接,那么优化器就必须确定连接计划(hash、sort merge或nested loop),以及评估或连接表的次序。

Listing 1. Merge-sort using the fork-join library.

清单1 .使用fork - join库进行合并排序。

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

哈希连接通常比分类合并连接快,因为它没有涉及到分类操作。

Merge scan join (MSJOIN) with sort for outer and inner

使用内部和外部排序的合并扫描联接 (MSJOIN)