04-25-2008 10:10 AM
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...
04-25-2008 10:13 AM
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
04-25-2008 10:13 AM
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
04-25-2008 10:14 AM
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
04-25-2008 10:15 AM
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