Skip to Content
Former Member
Dec 12, 2013 at 05:57 AM

Why are CE functions faster than SQL?



I know that calculation views built using CE functions give much faster results as compared to calc views using SQL.

I am also aware of the fact that pruning helps in improving the performance.

But if we have a table and we expose all the columns in a script calc view using 1.CE functions and 2.SQL functions

we can see that CE function based calc view is much faster if we do a select * query.

I read that CE functions are more optimized.

Can somebodyplease explain in more detail what is meant by "more optimized"?

Looking forward to your inputs.

Best regards,

Sidharth Mishra