IBM Mainframe Forum

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?

Try EXPLAINing the query. If your tables have appropriate indexes defined, you should not be having a problem.

Hello,

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