Skip to Content

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

Intraquery parallelization of HANA queries

Through the great book SAP HANA Administration from Richard Bremer and Lars Breddemann I learned that there are two types of parallelism(Interquery and Intraquery parallelization) . For interquery parallelization it is mentioned that every statement needs his own SQLExecutor thread. I guess this is also valid for a statement which is splited into several parallel processing steps(intraquery).

So my question: Does every parallel processing step of a single query needs his own SQLExecutor thread?

Thanks,

Patrik

Tags:
Former Member
replied

Hi Patrik,

happy to hear you like our book.

To answer your question: no, not every single step gets its "own" SQLExecutor thread.

In fact, the number of SQLExecutor threads in the system is rather stable and the threads are shared among all sessions.

Having said that, every POP needs at least one execution thread to be executed,

- Lars

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