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
|