How does a join stage work?
Posted: Wed Jul 14, 2010 10:17 pm
Hi
Could any one explain me how does a join stage work from conceptual perspective?
If i have some 10 million recs on each i/p how/where does the join stores that data in order to compare/find a match/How it make use of memory and buffer etc?
Please let know if you need more details...
Could any one explain me how does a join stage work from conceptual perspective?
If i have some 10 million recs on each i/p how/where does the join stores that data in order to compare/find a match/How it make use of memory and buffer etc?
Please let know if you need more details...