sort-merge join implementation for the given query

[mythologyrocks]

Hi all,

This is my given query:

Select * From T1, T2 where T1.PK = T2.C2 and T1.C3 = T2.C3

where T1 table has the integer fields P1,C1,C2 and T2 has integer fields PK1,C21,C31. I need to implement the above as a sort-merge join in C or C++ or Java, etc. Language ain't the problem. I can't understand what sort-merge join is. Any help is appreciated.

Regards,
Mythologyrocks!!!

 

[dbtoo2001]

In my humble opinion: This sounds an awful lot like a theory question that would be posed by an instructor....An employer wouldn't care how you obtain the data, only that it is obtained Correctly and Quickly.......

Read:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/optimops.htm#49760