Share your recently acquired knowledge across your social and professional networks.

{learning-journey-title}

Record of Achievement

AcknowledgeBadgeCourses.png

Pass all the quizzes and receive a digital badge

Record of Achievement

Record of Achievement Courses

Share feedback

Planned maintenance of Practice Systems

Planned maintenance of Practice Systems

Why create an SAP account?

Enhance your learning experience

SAP Learning

Subscribe now

Learn more

Live Sessions

Hands-on Practice

Certification

My Learning

Ready to start learning?

ST (MMCP-Storage) - 2024-05-08T16:03:18.116Z)

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

Now you have the chance to earn points towards your record of achievement. The specific details of the quiz are listed below. You’ll have one attempt at getting the questions right, so please make sure to check your answers before saving them.
We strongly recommend that you avoid guessing in multiple-answer questions, and only select the answers that you are sure about. Check the [**evaluation of exam performance guidelines**][1] for further details. 

Before you begin, check your browser is compatible. You can find the requirements on our [**FAQs page**][2]. If, for some reason, you get disconnected, try to reconnect within the given time and you’ll still be able to finish the quiz. If you have any other issues, please contact the **openSAP Helpdesk**.

[1]: https://open.sap.com/pages/roa_guidelines#4-evaluation-of-exam-performance
[2]: https://open.sap.com/pages/faq#what-are-the-technical-prerequisites-for-the-weekly-assignments-and-final-exam

Unit Assessment

Assignment Week 1

SAP HANA Query Processing

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

Assignment Week 2

Column Search and Analysis Tools

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

Assignment Week 3

Methods for Query Performance Analysis

Methods for Query Performance Analysis

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

Assignment Week 4

Case Studies

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.