Utility to match records between 2 tables



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Utility to match records between 2 tables

Postby Mann_B » Tue Feb 22, 2011 3:48 pm

Hi

We are using INNER JOIN operation to match the records from 2 tables based on account number but as there are huge records ,huge matching is happening and it is taking lot of time.
Do we have any utility or operation that gives better performance and efficiency?
Mann_B
 
Posts: 79
Joined: Wed Mar 31, 2010 11:48 am
Has thanked: 0 time
Been thanked: 0 time

Re: Utility to match records between 2 tables

 

Re: Utility to match records between 2 tables

Postby stevexff » Tue Feb 22, 2011 9:07 pm

Try EXPLAINing the query. If your tables have appropriate indexes defined, you should not be having a problem.
Steve
stevexff
 
Posts: 56
Joined: Wed Nov 10, 2010 7:48 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Utility to match records between 2 tables

Postby dick scherrer » Wed Feb 23, 2011 1:05 am

Hello,

If you are JOINing hundreds of millions of rows, it will take time. . . As it should. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post