You are running a report. It is taking long time for
execution. What steps will you do to reduce the
execution time.
Answer Posted / 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 |
Post New Answer View All Answers
What is a table cluster? : abap data dictionary
Mention what is alv programming in abap?
What is the difference between the function module and a normal abap/4 subroutine? : abap modularization
How to define selection screen?
function modules are also external subroutines. State true or false. : abap modularization
What is runtime analysis?
How many ways you can create table? : abap data dictionary
Type casting and error handling
can any one answer these questions 1)How do you convert non-character field to character field? 2)How do you work with semi colon separated files? 3)why cant we use normal function module for data transfer? 4)what is the structure of CTU-PARAMS? 5)can we use transfer dataset to transfer data in internal table?
Power is interrupted while transferring data from internal table to application server. How will you determine many records are transferred in session method and call transaction method? : abap bdc
What are authorization objects and what statement is used to perform an authorization check in an abap program?
What are the different attributes that can be assigned to a variant?
What are the dis-advantages of logical databases? : abap hr
How to create user interfaces for lists?
Which transaction code is used executing a report (type 1 program)? : abap data dictionary