/
Browse
/
Courses
/
Using the Optimizer for SQLScript Programming in SAP HANA
/
SQLScript supportability – M_ACTIVE_PROCEDURES
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
SQLScript supportability – M_ACTIVE_PROCEDURES
Next lesson