Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 19, 2015 at 03:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded