Examples of operations that use the sort heap include hash joins and operations where the table is in memory.
使用排序堆的操作示例包括内存中表的散列连接和操作。
This dynamic filter on the fact table reduces the number of rows used in the probe phase of the actual hash joins.
事实表上的动态过滤减少了实际散列连接探测阶段使用的行数。
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.
利用下推连接技术的星型连接计划使得散列连接更加有效的主要原因是,在初期减少了事实表(探测表)的行数。
应用推荐