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

We are aware of intermittent issues in accessing the learning content

We are aware of intermittent issues in accessing the learning content

Why create an SAP account?

Enhance your learning experience

SAP Learning

Choose your subscription

Manage your subscription

Live Sessions

Hands-on Practice

Certification

My Learning

Ready to start learning?

Please try again later

Sorry, we encountered an error

Try again or reset results to continue browsing

We didn’t find what you’re looking for

To continue, please log in

Your session has timed out

Explore {title} at SAP Learning. Find out more!

Quiz

Congratulations on completing this {objType}

Practice your skills in a live SAP environment

Certification Exam

Theoretical Exam

Practical Exercise

Practical Test

External Hands-On

Practice System

Assessment

Subscription

Course Completion

Knowledge Badge

External Course

External Resource

Learning Journey

Learning Journey Assessment

Lesson

Live Session

Course

Stay Certified

Test Out

Unit

Video

Video Playlist

Week

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.