SAP Certified Development Specialist – ABAP for SAP HANA 2.0 — Question 5

Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? (Choose two.)

Answer options

• A. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement
• B. Perform all calculations and aggregations in the ABAP layer
• C. Ensure the WHERE clause contains at least one index field
• D. Ensure the access to buffered tables uses the SAP table buffer

Correct answer: C, D

Explanation

Correct answers C and D focus on optimizing data retrieval by ensuring that indexed fields are utilized and that buffered tables are accessed efficiently. Option A is less efficient as it suggests using SELECT FOR ALL ENTRIES, which can lead to performance issues if not used correctly. Option B is incorrect as it is better to perform calculations in the database layer for improved performance.