Share feedback

Follow guided learning and develop the skills you need at your own pace

Join a moderated learning group to engage with our experts and peers

Find the right learning resources to drive your career as a developer

Sign up to access exclusive student learning journeys

Discover the SAP product knowledge you need to help you progress in your career

Develop your skills

Learn.png

Want to learn more about the value of learning with SAP?

View available SAP Certifications on SAP Learning 

Purchase a subscription and book your exam

Validate your SAP expertise

SAP Certification validates your skills, sets you apart from the crowd, and demonstrates you have the knowledge you need to succeed.

Certify.png

Accelerate your career 

Upskill in key innovation topics through openSAP's free, expert-led online courses, microlearning, and podcasts.

Join SAP Community and connect with a global network of experts and peers to ask and answer questions.

Search for SAP product documentation or browse all SAP Learning Journeys to become competent in the SAP solutions you need.

Log in to SAP Learning Hub and access the entire SAP Learning portfolio, live practice systems, and social learning opportunities.

Find free tutorials, trials, downloads, and technical product information in the SAP Developer Center.

Book live classes (online and in person) and purchase SAP Certification and SAP Learning Hub subscriptions.

Explore_More.png

Navigate easily between training and support sites

Why create an SAP account?

Enhance your learning experience

og_default_image.png

Intermittent issues

Switching to SAP Universal ID

SAP Learning

Manage my account

Inbox

Bookmarks

Achievements

Consent Management

SAP.com

SAP Community

SAP for Me

Live Sessions

Hands-on Practice

Certification

My Learning

Ready to start learning?

Understanding SAP HANA SQLScript Optimizer

Understanding SAP HANA SQLScript Optimizer

SAP HANA SQLScript Supportability Features

SAP HANA SQLScript Supportability Features

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.