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?
Lars Breddemann replied
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,