topic Inner Join performance problem. in Application Development and Automation Discussions

Inner Join performance problem.

Former Member — Wed, 18 Feb 2009 05:58:27 GMT

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.

Re: Inner Join performance problem.

JoffyJohn — Wed, 18 Feb 2009 06:04:51 GMT

what r the joining condition.?

Please analyze this report in SE30 tcode

Re: Inner Join performance problem.

Former Member — Wed, 18 Feb 2009 06:05:16 GMT

hi,

select all the primary key

if possible use view instead of join

see this link

thanks

Re: Inner Join performance problem.

Former Member — Wed, 18 Feb 2009 06:12:29 GMT

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...