/ Browse / Courses / Using the Optimizer for SQLScript Programming in SAP HANA / Case study 2 – Using BIND_AS_VALUE

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
Quiz

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
Quiz

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
Quiz

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
Quiz

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
Quiz

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
Quiz

Case study 2 – Using BIND_AS_VALUE