本文介绍了一种名为分区连接的数据库优化技术。该技术通过将连接操作分解为更小的并行或顺序连接来提高处理效率。分区连接可以显著减少平行处理过程中数据交换的数量，从而提高整体性能。
A partition-wise join is a join optimization for joining two tables that are both
partitioned along the join column(s). With partition-wise joins, the join operation is
broken into smaller joins that are performed sequentially or in parallel. Another way
of looking at partition-wise joins is that they minimize the amount of data exchanged
among parallel slaves during the execution of parallel joins by taking into account data
distribution.[@more@]
partitioned along the join column(s). With partition-wise joins, the join operation is
broken into smaller joins that are performed sequentially or in parallel. Another way
of looking at partition-wise joins is that they minimize the amount of data exchanged
among parallel slaves during the execution of parallel joins by taking into account data
distribution.[@more@]
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1002504/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-1002504/
扫一扫
1051
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
