Community members are happy to help you with your troubleshooting and performance tuning problems, but before posting, please make sure you have done some analysis to find where the problem in your program lies. Two of the more helpful transactions are the performance analysis (transaction ST05) and the runtime analysis (transaction SE30). If you are unsure about how these transactions work, here are a couple of blogs (both by siegfried.boes) to get you started:
The SQL Trace (ST05) – Quick and Easy
The ABAP Runtime Trace (SE30) - Quick and Easy
and by hermann.gahm:
Single Transaction Analysis (ST12) - Getting Started
Explaining the SQL Explain Plan
Transaction SAT is replacing SE30 from Netweaver 7.0 EhP2. An excellent introduction by olga.dolinskaja can be found here:
Next Generation ABAP Runtime Analysis (SAT) - Introduction
Also, code inspector can do some static performance checks before your code hits large databases, randolf.eilenberger wrote a series of blogs about it:
Code Inspector's Performance Checks
Look out for additional publications by these authors!
Additionally – the following questions have been asked and answered many times before, so please do not ask them again:
Which is better: A JOIN or FOR ALL ENTRIES? -> For All Entries is NOT better than INNER JOIN in most cases
Which is better SELECT/ENDSELECT or SELECT INTO TABLE? -> SELECT INTO TABLE
Which is better MOVE-CORRESPONDING or MOVE individual fields? -> Using MOVE-CORRESPONDING - Myth to Meaningful
Tell me about performance tuning? -> tcode for performance tuning and usefull links and material for pt
Which is better MOVE or = ? -> Move and "=" Difference
Which is better SELECT SINGLE or SELECT UP TO 1 ROWS? -> Select Single Vs Select upto 1 row
Furthermore, memorable discussions about ABAP performance issues are collected here:
FAQ's, intros and memorable discussions in the ABAP Testing and Troubleshooting Space
Please do not post answers that violate these rules. Points may be unassigned as well to discourage responders from helping those who won't help themselves.
Please search the discussion space. Questions like these will be locked or deleted as soon as they are noticed.
Note that this list is not exhaustive. You can make sure your post won't be locked by first searching the discussion space to see if the question you need answered has already been answered.
Please do not respond to questions that violate these rules. Simply click the "report abuse" link and the moderators will take care of the rest.
(original "ABAP Performance and Tuning" forum sticky thread created by rob.burbank)
