Skip to Content

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

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

Hi

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.

Krisztian

Tags:
Former Member

Helpful Answer

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