You are running a report. It is taking long time for
execution. What steps will you do to reduce the
execution time.
Answer / pradipta mahato
Hi,
Ideally we should follow following thing for good performane
1. Avoid select inside loop (select out of loop and read it
inside)
2. Avoid nested loop and unnecessary extra loop in code
3. Change loop to read if there is a chance
4. Avoid join better use 'for all entries'
5. read internal table using binary search ( Sort it first)
6. If select statement creating problem then index could be
created
Is This Answer Correct ? | 7 Yes | 1 No |
how will you go for row level locking of a z table
2 Answers HP, IIIT, KPIT, Rajiv Gandhi University of Knowledge Technologies RGUKT,
Events in Interactive Report?
What is the procedure you followed to upload the data?
What are the basic functions of database utility?
What is the difference between internal tables and extract datasets? : abap modularization
what is use of STOP stsment
why abap/4 is 4th generation language ?
4 Answers Kansai Nerolac Paints Limited,
When we append a record to a sorted internel table how it is appended?
what are system Variables?
how do the sub-total in sap scripts
Explain V2 updates
What are the difference between tables and structures?