Database Reference
In-Depth Information
Figure 10-3.
Execution plans with and without a scalar user-defined function
A user-defined function adds the
Filter
operator to the execution plan. Although the costs for both, operator and
query, are way off.
If you run SQL Server Profiler and capture
SP:Starting
event, you would see the screen shown in Figure
10-4
.