SAP Professional Journal –
One of the most common reasons for slow-running ABAP programs is long-running SQL statements, which can cause over-consumption of database and network resources, and ultimately, decreased performance. So how can you prevent your SQL statements from causing this? This article provides an overview of database access optimization. It discusses the various techniques available for speeding up data access and, using sample code along the way, illustrates these techniques in action and points out the most common coding mistakes developers make.