What are steps you follow to improve the performance of a
report ?
Answer Posted / lokesh
Performance of the report can be improved by reducing the
data transfer .
1) Having an internal table without a work area is better
for performance.
2) Use FOR ALL ENTRIES in your SELECT statement to retrieve
the matching records at one shot.
3) Avoid using nested SELECT statement, SELECT within
LOOPs.
4) Avoid using INTO CORRESPONDING FIELDS OF TABLE. Instead
use INTO TABLE.
5) Avoid using if/endif instead use CASE/ENDCASE
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What happens when you post goods issue after delivery? How does the inventory get reduced after the delivery?
Is a logical database a requirement/must to write an abap/4 query?
What are the functional areas, user groups? How does abap query work in relation to these?
What is the difference between collect and sum?
Name the abap/4 modularization techniques?
What are the control break events in abap? : abap data dictionary
How will you transfer data into a file in application server?
Is it possible to pass data to and from include programs explicitly? : abap modularization
In order to upload purchase order details, how you handle multiple values for a single field?
What are the events in abap/4 language? : abap hr
What is a size category? : abap data dictionary
How can we use multiple transactions by using bdc_insert? : abap bdc
Performance tuning techniques
What is hotspot?
Explain the difference between a dialog program and a report?