Apr 28th, 2009, 10:39 AM
How to combine queries for DB2 and oracle
Title may be bit misleading, this is the actual scenario:
>I am querying DB2 for list(parm1,parm2),resultset size-3 million
>And next i am querying Oracle for list(parm1,parm4,parm5)result size:4 million
So u can see that they have one parameter(parm1) in common, i need to loop through two results sets and see where the value of the parm1 equal in both the resultsets and do some logic with other parameters.Right now the way i am doing is running two for loops, which runs for like 12X10^12 times, which takes a lot of time.Can any one gimme some optimized(like querying two databases at atime) way to do this plzz.