Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

indexes, sorted table, subqueries and other performance tips.

Hello experts,

I was just given a report by my boss that needs to be optimized. As I browsed through the report, I noticed that some of the comparisons in the select statements uses fields that are not primary keys. So my teammate said that I put indexes and instead of sorting the internal table after all of the select statements, I wonder if a sorted table is much better. Also, I am curious if using subqueries is better and faster that say, FOR ALL ENTRIES. I am currently new to ABAP so if you guys can post examples on how to put an index, how to make my standard itab to a sorted table, using subqueries instead of for all entries, etc. Thanks a lot guys and take care!

Tags:
replied

hai viray,

u can refer the examples given in this link.

http://www.sap-img.com/abap/what-is-use-of-using-hashed-table.htm

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb366d358411d1829f0000e829fbfe/content.htm

hope this is helpful.

regards,

praba.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question