I found this article which describes Scalar Functions acting as cursors. Use the Table-Inline Function instead. Adam found that it was 288 times better in IO. Read article to understand the difference.
Adam Machanic : Scalar functions, inlining, and performance: An entertaining title for a boring post
Adam Machanic : Scalar functions, inlining, and performance: An entertaining title for a boring post
No comments:
Post a Comment