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