what happend if a select statement inside aloop....
Answers were Sorted based on User's Feedback
Answer / madhavi
nothing will happen, but sure there will be a performance
issues,.
because for every step it hits the database to seach for
the record based on condition.
so, this is not suggestable.
Is This Answer Correct ? | 20 Yes | 0 No |
Answer / saplead.sai
There are cookbook rules in PERFORMANCE issues that are
needed to be addressed while coding. One of those rules
being .. Not to use a SELECT statment in a loop - Reason
(The basic idea of querry is to limit DB hits).
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / aashish mehta
It is not suggested to use select with in the loop as it is
related with the performance.
Is This Answer Correct ? | 7 Yes | 0 No |
25) Can we create more than one main window in smartforms?
What is report category and for what purpose do we use report category
There are 4 internal tables containing data. How to put it into a final table?
How do you get help in ABAP?
What is the full form of spro? : sap abap hr
Which table stores the programs created?
How can I download SAP SMARTFORM into text format?
What are the tcodes for performance tuning?
what is the diffrence between inner and outer join
is there any tping conversions in abp.and list them
how to debug a popup window?
What is the diffrence between Abstract Class and an Interface in OOABAP.