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.

• Understanding SAP HANA SQLScript Optimizer
• 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
• Assignment Week 1
• SAP HANA SQLScript Supportability Features
• 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
• Downloads
• Assignment Week 2
• Investigating SQLScript Performance Caused by SQL
• 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
• Downloads
• Assignment Week 3