I have tree tables (~10M row/table, 1k/row),
Is it better performance to use a merge stage in DS and send output to a DataSet or do a DB2 table join and fetch result to the DataSet?
The final DataSet should have ~ 9M rows
Thank for your advice
Merge VS DB2 Table join
Moderators: chulett, rschirm, roy
Re: Merge VS DB2 Table join
performance wise merge and join are almost the same..if you want the rejections as well u have to with merge..or else..both behave in the same way..
dtv2002 wrote:I have tree tables (~10M row/table, 1k/row),
Is it better performance to use a merge stage in DS and send output to a DataSet or do a DB2 table join and fetch result to the DataSet?
The final DataSet should have ~ 9M rows
Thank for your advice