Is there any benefit for natively compiled TVFs when used in non native modules?
2
votes
1
answer
352
views
I have some schema-bound **inline** table valued functions that I could natively compile.
However, my workflow does not use store procedures and it would only be invoked from entity framework or ado.net directly.
As the functions must be inlined into our queries, I fail to see a point in marking my functions as natively compiled. However, a colleague of mine wants to use it because it's shiny and new.
From some brief testing there seemed to be no actual benefit. Am I mistaken or could there beneficial scenarios?
Asked by Michael B
(519 rep)
May 11, 2019, 03:33 PM
Last activity: Jul 13, 2025, 07:03 AM
Last activity: Jul 13, 2025, 07:03 AM