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

Personalize your learning.

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?

This browser is not supported

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

Validate your skills and learning by completing the certification exam and gain a highly recognised accreditation.

Book your certification exam

Complete the assessment to validate your SAP PartnerEdge competency qualifications.

Ready to take your assessment?

Learn about the key features and essentials in the latest release to help you prepare for the Stay Certified assessment.

Prepare for assessment

Learn new skills you need at your own pace with our bite-sized lessons.

Prepare for certification

In your My Learning account you can view your certification and learn how to take your Stay Certified assessment.

Ready to take your Stay Certified assessment?

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

You have earned a new badge!

You've completed

Something went wrong when connecting to the badge service. You can always check your achievements in My Learning.

Badge couldn’t be issued

You’ve finished the course, but the external system didn’t verify it. Please try again later or refresh the page to update your record.

We couldn’t confirm your completion

The learning content has been updated. Refresh the page to reload the most recent content.

Your course content has changed

This badge was already awarded earlier, so no new one is added. You can view it anytime in My Learning.

You’ve already earned this badge

We couldn’t finish your request due to an unexpected error. Please refresh the page and try again. If the issue continues, check My Learning or try again later.

Something went wrong...

The saved progress data isn’t valid, so we couldn’t update your course status. Please try again later or refresh the page.

We couldn’t load your progress

Quiz

Congratulations on completing this {objType}

Subscribe to be informed about updates to this learning journey. We will inform you when a new unit is available.

Get notified

Practice your skills in a live SAP environment

Assessment

Course Completion

Knowledge Badge

Overview

Support Resource

Certification Exam

Theoretical Exam

Schedule

External Course

Practical Exercise

Practical Test

External Hands-On

External Resource

Learning Journey

Learning Journey Assessment

Lesson

Live Session

Practice System

Scenario Based Assessment

Course Assessment

Course

Stay Certified

Subscription

System Based Assessment

Test Out

Unit

Video

Video Playlist

Week

Your exclusive access to the SAP Learning Hub, event edition is ready. <link>Start learning now.</link>

Access activated

You can now register for free Live Sessions.

ST (MMCP-Storage) - 2024-05-08T15:06:25.674Z)

Course introduction

SAP HANA SQLScript optimizer

SAP HANA SQLScript optimization rules – Part 1

SAP HANA SQLScript optimization rules – Part 2

SQLScript general analysis strategy

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

Understanding SAP HANA SQLScript Optimizer

Understanding SAP HANA SQLScript Optimizer

SQLScript supportability

SQLScript supportability – SQL Trace

SQLScript supportability – Plan Profiler

SQLScript supportability – M_ACTIVE_PROCEDURES

SQLScript supportability – Explain Plan for CALL

SQLScript supportability – Plan Visualizer

Assignment Week 2

SAP HANA SQLScript Supportability Features

SAP HANA SQLScript Supportability Features

INLINE feature (Part 1)

INLINE feature (Part 2)

Case study 1 – Using the INLINE feature

BIND_AS_PARAMETER and BIND_AS_VALUE functions

Case study 2 – Using BIND_AS_VALUE

Using SQL hint in SQLScript

Pinning SQL hint for SQLScript

Assignment Week 3

Investigating SQLScript Performance Caused by SQL

Investigating SQLScript Performance Caused by SQL

Using the Optimizer for SQLScript Programming in SAP HANA

SQLScript is a programming language of SAP HANA to embed data-intensive application logic into the database. It supports imperative programming constructs like assignments, branches, loops, and exception handlers, as well as declarative Structured Query Language (SQL) queries. To run SQLScript efficiently and faster, the SQLScript engine uses the SQLScript optimizer. In this course, you’ll learn how the SQLScript optimizer works. You’ll discover the general analysis strategy for SQLScript performance issues associated with SQL query performance and the SQLScript optimizer, explore the supportability features of SQLScript, and review case studies.