Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Parallelization <=> serialization, when parallelization does not work?


The following are preventing parallel execution as far as I know:

Scalar parameters or variables used within procedure

SQL not assigned to variable

Has imperative and loop logic
Has DDL operations
operations that serialize (CASE )

In the following example temp1 and temp 2 can run parallel with Intra-Query Parallelism as well? temp3 will need the result of temp1 and temp2 so I quess no Inter-query Parallelism but what about Intra-Query Parallelism,in this point does HANA drop from the parallelization phase or temp 3 will be also run parallel just had to wait the result of temp1 and temp2?

What about  itab_all_bp  this will not run Intra-Query Parallelism because of the Case?

What are the other commands which serialize other than the Case?

Waiting for your valuable input.


Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question