I have two tables, table implements using List<int> structure.
The table has two columns(which mean int array is of size two)
Content of tablea
content of tableb
Now I wish to join two tables by field b, hence the result is
a b c
I know I can do this is sort merge join algorithms, and the algorithms is quite intuitive.
But I heard hybrid hashjoin(mentioned here http://en.wikipedia.org/wiki/Hash_join#_note-1
) is faster.
May I know how to use hybrid hashjoin algorithms to join tablea and tableb in C#(Preferably) or java?
(What I concern here is speed rather than space)