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.
Execution Time Scalar Function Execution Plan Filter Operator Type Conversion
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.
This is a preview of subscription content, log in to check access.