Inner Join performance problem.

[Former Member]

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.

[JoffyJohn]

what r the joining condition.?

Please analyze this report in SE30 tcode

[Former Member]

Hi,

Please:

1. Create DB view instead of inner join

2. Use the primary key of the base table (the first or main table in your view) in your where clause

3. If not possible, then you need to create secondary index in your base table that match with your where clause fields.

4. Try to use positive relationship operator, like EQ instead NE, GT, etc.

Hope it helps.

Lim...

[Former Member]

hi,

select all the primary key

if possible use view instead of join

see this link

thanks