DISTINCT:先对数据做重分布,再在各个node下执行去重;
GROUP BY:先在各个node下去重,再把结果hash重分布,再去重。
前 DISTINCT: Sort Unique 排序
↑ GROUP BY:Sort Group by 排序
10gR2
↓ DISTINCT: Hash Unique
后 GROUP BY:Hash Group by
DISTINCT:先对数据做重分布,再在各个node下执行去重;
GROUP BY:先在各个node下去重,再把结果hash重分布,再去重。
前 DISTINCT: Sort Unique 排序
↑ GROUP BY:Sort Group by 排序
10gR2
↓ DISTINCT: Hash Unique
后 GROUP BY:Hash Group by