Intraquery parallelization of HANA queries

[Former Member]

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

[lbreddemann · Accepted solution]

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