I find this related article very interesting:

http://blogs.msdn.com/mattm/archive/2008/11/25/lookup-pattern-range-lookups.aspx

It describes the performace differences from Lookup, Merge, and Script Component used to solve the same logic. Very cool reference.