Scalar Functions Caching
Posted on 2013-06-08
Hello my peers,
A question for Top Experts I always wandered but never dared to ask: Apart from rewriting the scalar functions as table-valued function, how can one guarantee that an inline function is not row per row processed but processed only once for all set ?
In other words, how can one properly cache inline functions ? I wander if any of you has found a way around this inherent limitation ?
PS: Please do not suggest use of anything else than functions. The entire point of this question is about optimal caching.
Thanks for your input.