Oracle Tuning for ABAP Developers

Every ABAP developer must be aware of the fact that all programs written in ABAP are processed by the SAP database interface, i.e. they can be or are modified. Moreover, the database optimizer determines (largely based on existing statistics) the execution plan for SQL*statements. This workshop aims to address precisely these challenges – because inadequate programming has a negative impact on response times.

The workshop includes special learning material.

No individual PCs are available for participants. Customer systems can be accessed within the scope of the workshop.

Audience

• Developer

Course Topics Overview of Oracle’s basic architecture Transactions (Oracle and SAP) Data access methods (index, full table scan, etc.) Indexes (basic concepts, secondary indexes, etc.) Using database hints in ABAP SE30, ST05, ST04, DB05 – when and how to use these transactions. Special ABAP constructs such as: for all entries, sort, check, in Bind variable handling Oracle optimizers (RBO, CBO) Pool (KAPOL) and cluster table access (BSEG) Processing joins Select single, up to n-rows – how these queries are implemented by the DB interface. Typical ABAP programming errors repeatedly encountered at the customer end Database statistics Advanced techniques (parallel query, materialized views, etc.) Analysis of customer programs
Course Objectives

• To acquire the skills needed to develop effective ABAP programs from the perspective of the database.