A question about sorted table...
Recently I have been trying to optimize a certain report. On a certain part of a report the original programmer made this statement:
sort it_vendor by lifnr akont.
Now, I tried to experiment using sorted table so I can hopefully cut the response time of the report. Below is what I did:
TYPES: BEGIN OF s_vendor,
lifnr LIKE lfb1-lifnr,
akont LIKE lfb1-akont,
END OF s_vendor.
DATA: it_vendor TYPE SORTED TABLE OF s_vendor WITH NON-UNIQUE KEY lifnr
My question is, is my sorted table have the same effect as the statement the original programmer did?T^hanks guys!
Rich Heilman replied
The biggest bang you will get for improving performance is making your select statements efficient. Make sure that your program is not spending too much time retrieving the data. Make sure that the select statements are using the keys of the table the WHERE clause(or the keys of an index). I would start there first.