Many queries have the form

select * from R,S where r.i=s.j and r.x=K

This would typically be evaluated as

Tmp = Sel[x=K](R)
Res = Join[i=j](Tmp, S)

If Tmp is small ⇒ may fit in memory (in small #buffers)