topic Re: difference between for all entries vs innerjoin in Application Development and Automation Discussions

difference between for all entries vs innerjoin

former_member223446 — Tue, 04 Sep 2007 09:50:23 GMT

hi dudes

let me know

what is exact difference between for all entries n innerjoin.

what r optimization techniques.

what is performance tunning.

advanced thanks

kiran

Re: difference between for all entries vs innerjoin

Former Member — Tue, 04 Sep 2007 09:58:50 GMT

hi ,

innerjoin : join the two tables when primary key relation is compalsary.at a time join three tables only

forallentries : joining the two tables primary key is not requried but same field existing in two tables.

Re: difference between for all entries vs innerjoin

Former Member — Tue, 04 Sep 2007 10:21:40 GMT

Hi,

for performance tuning refer to the below site.

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

Regards,

Bindu.

Re: difference between for all entries vs innerjoin

Former Member — Tue, 04 Sep 2007 13:54:26 GMT

In Innerjoin Tables are combined at the data base level. In for all entries tables are joined at Application server.

Performance wise for all entries is better than innerjoin if number of tables to join is more than two.

To use for all entries you have to check the first table initial are not. If it is initial then selection will be unlimited. So you have to check it first and then only use it in for all entries.

Re: difference between for all entries vs innerjoin

Former Member — Thu, 13 Sep 2007 11:58:29 GMT

The most important difference between a inner join and FOR ALL ENTRIES is that the inner join is performed between two Database Tables. While for all entries is an operation between a Database Table and an Internal Table.

For all entries it is always necessary to check whether the driving table is empty or not.

useful Rewards points*****************

Re: difference between for all entries vs innerjoin

Chandra-Bade — Fri, 14 Sep 2007 08:48:47 GMT

hi all,

" Inner join" best sutable for when u are accesing data from data base. but "for all entries" it is best when u are using more than 2 tables. both work similarly other than this performance issue reducing the newtwork load