User-Defined Functions

  • Dmitri Korotkevitch
Chapter

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.

Keywords

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.

Copyright information

© Dmitri Korotkevitch 2016

Authors and Affiliations

  • Dmitri Korotkevitch
    • 1
  1. 1.TampaUSA

Personalised recommendations