A First Step Towards SAP HANA Query Optimization

This course focuses on optimizing query performance in SAP HANA. It covers analyzing and solving out-of-memory issues, understanding SQL processing, learning about the SAP HANA SQL optimizer, and improving SQL performance with SAP HANA-specific features. The course also explores performance analysis tools and includes demos and case studies.

• SAP HANA Query Processing
• Course Introduction
• SQL Query Processing in SAP HANA
• SQL Queries – Order of Execution
• Hands-On: Simple Query Execution
• SQL Optimizer – Architectural Overview
• Parameter-Aware Optimization
• Hands-On: Understand Parameter-Aware Optimization
• Downloads
• Assignment Week 1
• Column Search and Analysis Tools
• Column Search
• SQL Trace
• Explain Plan
• Visualized Plan
• Trace for Parameterized Query
• Column Searches in the Traces
• How to Analyze Out of Memory (OOM) Dumps
• Downloads
• Assignment Week 2
• Methods for Query Performance Analysis
• Query Analysis – Overview
• Concepts of Dominant Operators and Possible Key Reducers
• Techniques Using Dominant Operators and Possible Key Reducers – 1
• Techniques Using Dominant Operators and Possible Key Reducers – 2
• Hands-On: Simple Query Performance Analysis 
• SQL Tuning Tip – 1
• SQL Tuning Tip – 2
• Downloads
• Assignment Week 3
• Case Studies
• Case 1 – Sporadic Composite OOM
• Case 1 – Plan Comparison and Analysis
• Case 1 – Issue Conclusion
• Case 2 – Find Dominant Operator and Possible Key Reducer
• Case 2 – Finding SQL Hint
• Case 2 – Simulating the Query Processing with SQL Hint
• Case 2 – Applying the Solution
• Downloads
• Assignment Week 4