ABAPAdvanced
Performance Tuning
Master ABAP performance tuning with SQL optimization, ST05, SAT, SQL Monitor, internal table strategy, buffering, package processing and real production debugging.
Overview
Master ABAP performance tuning with SQL optimization, ST05, SAT, SQL Monitor, internal table strategy, buffering, package processing and real production debugging.
Lessons in this topic
- HANA Pushdown with Open SQL, CDS and AMDPUnderstand what logic should be pushed to HANA and what should stay in ABAP.
- Package Processing for Large Data VolumesProcess large datasets safely without memory overflow or long locks.
- Rule of Thumb: DB FirstWhy tuning ABAP loops before SQL is usually wrong.
- ABAP Performance Tuning in Real ProjectsPractical performance tuning patterns used on real ABAP projects — from SELECT-in-LOOP fixes to ST05/SAT analysis.
- Internal Table Performance: Standard, Sorted and HashedPick the right internal table type for lookup, range access and sequential processing.
- Measure First: ST05, SAT and Runtime EvidenceLearn why performance tuning must start with measurement instead of guessing.
- SELECT Inside LOOP: The Classic Performance KillerUnderstand why SELECT inside LOOP is dangerous and how to replace it with bulk fetch and lookup.
- FOR ALL ENTRIES: Correct Use and Hidden RisksUse FOR ALL ENTRIES safely by checking empty driver tables and removing duplicates.
- JOIN vs FOR ALL ENTRIES vs Nested SELECTChoose the right data retrieval pattern for performance and maintainability.
- Indexes, Selectivity and WHERE ConditionsUnderstand when indexes help and why WHERE condition design matters.
Interview questions covered
- How would you use parallel processing (aRFC or bgRFC) to shorten a batch run, and what risks do you plan for?
- What is the risk of using FOR ALL ENTRIES with an empty internal table?
- Why is SELECT inside LOOP considered bad for performance?
- A nested LOOP AT itab1 / LOOP AT itab2 WHERE key = itab1-key is a hotspot. How do you refactor it?
- A report runs for 2 hours on production and 5 seconds in DEV. How do you approach tuning?
- How do you decide between JOIN, FOR ALL ENTRIES and CDS for performance?
- You need to reduce end-to-end latency of a Fiori OData list from 8s to under 2s. Walk through your plan.
- What is ABAP performance tuning?
- How do you optimise a LOOP AT itab WHERE ... on a large standard table?
- A job is fast in DEV/QA but slow in production only during month-end. Where do you start?
- A memory dump (TSV_TNEW_PAGE_ALLOC_FAILED) occurs in a report processing 3M rows. What do you change?
- What is code push-down and how does it change your ABAP performance mindset on HANA?
- A report takes 30 minutes. How would you start performance analysis?
- How would you assess the performance regression of a transport before releasing it to production?
- How does HANA change ABAP performance tuning?
- Explain buffered vs non-buffered DB tables and when buffering hurts more than it helps.