Please enable JavaScript.
Coggle requires JavaScript to display documents.
HA400-2 - Taking ABAP to SAP HANA - Coggle Diagram
HA400-2 - Taking ABAP to SAP HANA
Performance Rules and Guidelines
Keep result sets small
Use the WHERE and HAVING clauses
Select as few fields as possible, especially from tables in the column store
Minimize amount of transferred data
Use SELECT with a field list, instead of SELECT *
/
Minimize number of database accesses
Use JOINs and / or sub-queries instead of nested SELECT loops
Use SELECT... FOR ALL ENTRIES instead of SELECTs or SELECT SINGLEs
Use array variants of INSERT, UPDATE, MODIFY and DELETE
Use mass processing wherever possible
Select all rows and columns in one SQL statement
Minimize search overhead
Formulate clauses to fit with the database table indexes
WHERE clauses using non-indexed fields are not so bad anymore
Keep unnecessary load away from DB
Avoid reading data redundantly, use table buffering (if applicable) and do not bypass it, and sort data in your ABAP programs
Push data-intensive calculations to SAP HANA
Access to SAP HANA database by using Open SQL
Objects only known to SAP HANA (such as SAP HANA views or procedures) are not accessible by Open SQL
Native SQL has to be used (ADBC or EXEC SQL)
New objects have to be cretad in the ABAP dictionary
/
Guided Performance Analysis
Identify the most important database access
SQL Monitor (SQLM)
/
Combine static and dynamic performance analysis results
SQL Performance Tuning Worklist (SWLT)
/
Depth analysis of database accesses
SQL Trace (ST05)
/
Tools to analyze potential functional and performance issues in ABAP programs
Locate potential and performance issues
Code Inspector (SCI) with check variant DEFAULT
SELECT statements in LOOPS across modularization units
Problematic SELECT * statements
Finding SELECT... FOR ALL ENTRIES statements that can be replaces by a join
ABAP Test Cockpit (ATC)
Holistic quality assurance tool
/
Measure and compare runtime consumption
ABAP Trace (SAT)
Replaces the older Runtime Analysis (SE30)
/
ABAP Profiling perspective in ABAP Development Tools