Performance wise

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

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