Tuesday, March 3, 2009

Scalar Function Performance...

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

No comments:

Post a Comment