When to use a graphical CV in SQL Engine

[Former Member]

Hi,

Can anyone help me When to use a graphical CV in SQL Engine or when in normal mode.

Sometimes it takes a long time to execute and sometimes it executes quickly in SQL engine.

-

Thanks,

Subhash

[vivekbhoj]

Hi Subhash,

Please refer SAP Note 1857202 SQL Execution of calculation views and read the attached PDF.

An excerpt  from the attached document:

"When the “Execute in” property is switched to “SQL Engine” (Enforce SQL Execution) in a graphical Calculation Model the Calculation Engine tries to generate SQL out of each node during runtime. After generating SQL for each node (if possible) the SQL statements are combined into one big SQL statement which is then passed to SQL interface. This might be beneficial as SQL interface also involves standard SQL optimizer which implements a lot more optimization rules than Calculation Engine. E.g., most important rule is join ordering determination.

This option is only efficient if every node can be translated so that one big SQL statement can be generated."

Regards,

Vivek