[prev] 23 [next]

Sort-Merge Join (cont)

Cost of sort-merge join.

Step 1: sort each relation   (if not already sorted):

  • Cost = 2.bR (1 + logN-1(bR /N))  +  2.bS (1 + logN-1(bS /N))
                (where N = number of memory buffers)
Step 2: merge sorted relations:
  • if every run of values in S fits completely in buffers,
    merge requires single scan,   Cost = bR + bS
  • if some runs in of values in S are larger than buffers,
    need to re-scan run for each corresponding value from R