Thursday 30 April 2009

UDF Performance Issues

Excellent post by MVP Gail Shaw on how user defined functions can hurt performance by introducing row-by-row processing.

http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/

r

No comments: