Page 1 of 1

Utility to match records between 2 tables

PostPosted: Tue Feb 22, 2011 3:48 pm
by Mann_B
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?

Re: Utility to match records between 2 tables

PostPosted: Tue Feb 22, 2011 9:07 pm
by stevexff
Try EXPLAINing the query. If your tables have appropriate indexes defined, you should not be having a problem.

Re: Utility to match records between 2 tables

PostPosted: Wed Feb 23, 2011 1:05 am
by dick scherrer
Hello,

If you are JOINing hundreds of millions of rows, it will take time. . . As it should. . .