inner joins Vs for all entries

[Former Member]

Hi All,

Pls let me know

the differences b/w innerjoins and for all entries,,,,which is the best option and Y??

Thanks in Advance,

Bye

[pavel_parshenkov2]

it depens on tables (count of rows), selected keys, linking keys for join . etc.

do u have intristing example ?

[Former Member]

Hi,

For performance wise you can use for all entries. If you are using two or three tables you can go inner join, more than three you can prefer for all entries.

Regards,

Bhaskar

[Former Member]

hi,

chk these...

https://forums.sdn.sap.com/click.jspa?searchID=1981649&messageID=3165251

https://forums.sdn.sap.com/click.jspa?searchID=1981649&messageID=3069593

https://forums.sdn.sap.com/click.jspa?searchID=1981681&messageID=2873823

regards,

priya.

[Former Member]

Hi!

INNER JOIN is used if we want to retrieve some data from more than one table.

FOR ALL ENTRIES is used if we want some data from a table based on some conditions of some other table.

Using several nested INNER JOIN statements can be inefficient and cause time out if the tables become too big in the future."

In ABAP, these joins are first split by the ABAP processor and then sent to the database, with the increase in DATA in production system, these joins tend to give way if your database keeps growing larger and larger.

You should rather use "FOR ALL ENTRIES IN" (Tabular conditions), which is a much efficient way as far as performance is concerned.

Check these links:

Reward points if it helps.

Regards

Sudheer

[Former Member]

Performance will also depends of your data volume.

A FOR ALL ENTRIES request is going to group 5 entries and send a SELECT request for all of groups created.

If you have a high volume of data, INNER JOIN might be faster.

Regards,

Mathieu

Message was edited by:

Mathieu ILHE