Skip to Content

HANA - Scalar Function not executing in parallel

Hi,

My cenario is:

  1. 1 Graph Calc view calling
  2. 1 SQLScript View that execute a SQL with 2 scalar function

I have 2 ScalarFunction in HANA to execute some complex-logic for a data range. I execute both separately and time results are:

select value, Scalar_Function1(value) from table

--> 14sec

select value, Scalar_Function2(value) from table

-->16sec

So, if I try execute the both ScalarFunction on same SQL the result time is:

select value, Scalar_Function1(value), Scalar_Function2(value) from table

-->30sec

I think hana is not running this SQL statement in parallel mode. What is necessary to do for parallel execution of this Functions?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 30, 2017 at 12:04 PM

    what Hana version? What does the explain plan looking like? How many parallel threads provide your system?

    Add comment
    10|10000 characters needed characters exceeded