topic Re: Performance wise in Application Development and Automation Discussions

Performance wise

Former Member — Fri, 25 Apr 2008 09:10:45 GMT

Hi xperts,

i need a small clarification .can we use

Inner joins in Ecc.

Some are saying If we use Inner Joins we will face performance problems in ecc.

Thanks

Suri...

Re: Performance wise

Former Member — Fri, 25 Apr 2008 09:13:44 GMT

Hi,

Nothing like that... you can use Inner Joins in ECC

If the tables are more than 2 or 3 then better to go for For all entries instead of using Inner Joins.

Regards,

Satish

Re: Performance wise

Former Member — Fri, 25 Apr 2008 09:14:00 GMT

Not all Inner Joins are problematic(in ecc or any other version). Some cases they are better than individual selects. Join with the key fileds are better to use.

regards,

madhu

Re: Performance wise

Former Member — Fri, 25 Apr 2008 09:15:22 GMT

hi Suresh,

Split the select statement in to two selects and use for all entries statement instead of joins ...

Check this otu

http://www.sap-img.com/abap/select-statement-with-inner-join-is-taking-forever.htm

Regards,

santosh