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.