SELECT-Performance in ABAP

Four little tips to improve SQL performance in ABAP

Tip 1:



Basically the query with

is more efficient than the query

However, when later processing the selected matches in a loop (LOOP) carried out, it may be better to carry out this process in the same


Tip 2:

should be used only as a last resort, as this data is stored in memory that are not subsequently used.



Tip 3:

This results in only one access to the database and is therefore much faster than other SELECTs.


Tip 4:

Use key fields

Actually self-explanatory. By specifying all possible key spring in the WHERE clause, the network load and memory usage can be reduced because there can be accessed in this way on existing indexes.