/
Browse
/
Courses
/
A First Step Towards SAP HANA Query Optimization
/
Case 1 – Plan Comparison and Analysis
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
Quiz
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
Quiz
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
Quiz
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
Quiz
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
Quiz
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
Quiz
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
Quiz
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
Quiz
Case 1 – Plan Comparison and Analysis
Next lesson