You are running a report. It is taking long time for
execution. What steps will you do to reduce the execution time.
Answers were Sorted based on User's Feedback
Answer / venkateswari
in this u should n'tuse select *
do n't use nested selects
do n't use nested loops
do not use select and end select
do n't use use select query in a loop
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ajayrajareddy
i think we are not using any absolute statements,
must check the extended program check and rectify some of
the errors... and we never wright nested loops also....
Is This Answer Correct ? | 0 Yes | 0 No |
How do you know that data is updated in call transaction
What is the use of the raising exception? : abap modularization
What is the difference between select single and select upto 1 rows?
Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?
What loop do you code for a READ DATASET Statement
Name the special commands of list?
Specify the types of data dictionary objects.
What is the collect statement? How is it different from append?
what does it mean occurs 0 while creating an internal table ?
How can you remove leading zeros of a number in script?
what is a ticket?
My internal table exceed the limit. then it goes to dump. how will u handle this issue?