Understanding SAP HANA Engines

[former_member222293]

Hi,

I was reading about best practices for developing information models in SAP HANA SP11. It says that in Calculation view there is property Execute in which is if set to SQL Engine, all the queries will be processed in SQL engine and now from SP09 onward this property is implicitly set to always execute in SQL engine.

Does this mean that the calculation view will only be processed by SQL engine and no other engines will be used? Please help me understand that.

According to my understanding, SQL engine will only optimise the information view by converting all nodes into corresponding SQL statements and then passing those SQL statements to respective engines(OLA, JOIN and Calculation)

[former_member208449]

Hello Nikunj

 now from SP09 onward this property is implicitly set to always execute in SQL engine.

This is not true. Its not implicitly set to execute in SQL engine. We have an option to choose between SQL or calculation engine.