Do you use select statement in loop end loop, how will be
the performance? To improve the performance?
- 2 Answers
- 9024 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 is a database view? : abap data dictionary
What is the transaction code to display the payroll results ? : abap hr
A function module can be called from a transaction screen outside an abap/4 program. State true or false. : abap modularization
Can we make use of flow logic control key words in abap/4 and vice-versa?
Control Break statements- At new...endat.
What is native sql?
Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subrc after perform?
What are the layers of data description in r/3? : abap data dictionary
Explain the difference between a dialog program and a report?
what is the t-code to link technical and functional operation?
Explain the Importance of pa20? : abap hr
What are field symbols and field groups? Have you used component idx of structure clause with field groups?
What are the major steps will you use for tuning?
Polymorphism real time scenario
What is the meaning of client independent?
