Partition-wise Joins

tsinglee發表於2008-04-14
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@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-1002504/,如需轉載,請註明出處,否則將追究法律責任。