Lesson Summary
- Distinguish between HEX engine handling in SAP HANA Cloud and on-premise systems, noting the differences in capability and threshold checks.
- Describe the execution flow in SAP HANA 2.0 SPS07 and SPS08, emphasizing how threshold checks influence engine fallback decisions.
- Explain the purpose and availability of the "Auto Recompilation" feature for detecting and recovering from performance degradations.
- Outline the steps to enable auto-recompilation and set recompilation limits to prevent excessive recompilations.
- Summarize how the server monitors performance drops by comparing average CPU execution times and invalidates plans when thresholds are exceeded.