Parallel Processing and Parameters
January 5, 2021
Intermediate
15 min.
Leveraging SQLScript in stored procedures, user-defined functions, and user-defined libraries.
You will learn
- How to take full advantage of parallel processing in SAP HANA by using table variables
Prerequisites
- This tutorial is designed for SAP HANA on premise and SAP HANA, express edition. It is not designed for SAP HANA Cloud.
- Tutorials: Creating Stored Procedures
In this exercise, we will modify the code of procedure get_po_header_data
so that it takes full advantage of the parallel processing within HANA by using table variables.
Step 1: Edit previous procedure
Step 2: Assign SELECT statements
Step 3: Save and build
Step 4: Run the procedure again
Step 5: Check execution time