Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Performance wise

Go to solution
Former Member

‎04-25-2008 10:10 AM

0 Kudos

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

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎04-25-2008 10:13 AM

0 Kudos

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

3 REPLIES 3

Go to solution
Former Member

‎04-25-2008 10:13 AM

0 Kudos

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

Go to solution
Former Member

‎04-25-2008 10:14 AM

0 Kudos

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

Go to solution
Former Member

‎04-25-2008 10:15 AM

0 Kudos

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