for all entries

[Former Member]

Hi,

Give answer for this question

How can we optimize the logic in nested loops.Is there any standard way?

[Former Member]

Hi,

Give answer for this question

How can we optimize the logic in nested loops.Is there any standard way?

[Former Member]

a couple of suggestions:

1. Use inner join - this is normally more efficient.

2. select into an internal table where possible

3. define a database view in SE11

[franois_henrotte]

you should avoid nested loops

- either you SELECT with JOIN statement

- either you create a view in Data Dictionary and use it for selection

FOR ALL ENTRIES is possible but if the number of records is huge you will get performance problems

[rodrigo_paisante3]

Hi,

standard way: Keep distance of NESTED LOOPS

other ways: parallel cursor, indexed loop

how to find: search in the forum for "nested loop"

[You will find this blog|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3119] [original link is broken] [original link is broken] [original link is broken];

[and this one|/people/siegfried.boes/blog/2007/09/12/runtimes-of-reads-and-loops-on-internal-tables]

Thanks!