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.

DOI: 10.1007/978-1-4842-1964-5_11