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
![](http://img.zemanta.com/pixy.gif?x-id=879c4d4f-d756-4d2f-b101-86a20fe9cb8a)
Adam Machanic : Scalar functions, inlining, and performance: An entertaining title for a boring post
![](http://img.zemanta.com/pixy.gif?x-id=879c4d4f-d756-4d2f-b101-86a20fe9cb8a)
No comments:
Post a Comment