Research work · 2016
User-Defined Functions
Dmitri Korotkevitch
Apress eBooks
Abstract
This chapter discusses multi-statement and inline user-defined functions. It analyzes how SQL Server executes multi-statement functions and the performance impact they introduce. After that, this chapter demonstrates a technique that can help address those performance issues by converting multi-statement functions into inline ones. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.