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.
Overview
Syllabus
- 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
