Interested to Buy Any Domain ? << Click Here >> for more details...
Do you use select statement in loop end loop, how will be
the performance? To improve the performance?
- 2 Answers
- 10009 Views
- I also Faced
- E-Mail Answers
Answer Posted / sukhbir
Best option will be to select the data before loop and
inside loop use read statement.
select f1 f2 f3(key fields) from db into
iNtertab
for all entries in itab
where condition.
sort intertab by f1.
loop at itab.
read intertab with key f1 = itab-f1
binary search.
Endloop.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?
What is “call mode”?
Why cant we use Normal function module for data transfer?
Can a constructor be declared private? If yes then in which scenario?
What are the disadvantages of using explicit enhancement?
Which commands are used for interactive reports?
Can we use write statements in screen fields?if not how is data transferred from field data to screen fields?
Can you delete data element, which is being used by table fields. : abap data dictionary
What are the differences between table controls and step loops?
What is the use of the raising exception? : abap modularization
What is dialog module?
What is step-loop?
What happens if a function module runs in an update task? : abap modularization
What are the basic components of dialog program?
How to display or know if the value entered contains records or not?
