'10000 20000 200 1m' presentation slideshows

Lecture 28: Size/Cost Estimation, Recovery

291 views • 15 slides

Lecture 28: Size/Cost Estimation, Recovery

172 views • 15 slides

Lecture 27: Size/Cost Estimation

Lecture 27: Size/Cost Estimation. Monday, December 5, 2005. Types of Joins. Eqjoin: R(A,B) |x| B=C S(C,D) = T(A,B,C,D) Natural join: R(A,B) |x| S(B, C) = T(A,B,C) What is the difference from eqjoin ? Theta join: |x| q . E.g. R(A,B) |x| B > C S(C,D) = T(A,B,C,D)

163 views • 15 slides