Skip to Content
0
Former Member
Feb 18, 2009 at 05:58 AM

Inner Join performance problem.

36 Views

Hi,

I wrote a select statement using inner join on table VBRK , VBUK, VBAP and VBRP.

This select statement is working fine from last two years, but suddenly to execute this select statement

taking lot of time and program going to dump.

But same select statement is working in development and quality systems and not working in production system. Based on given selection we check the tables in production we found only 10 records, but to fetch these 10 records also it will taking lot of time and going to dump.

can anyone please advise on the same.

Thanks in advance.