I have a table valueUDF that has recently started to perform rather poorly. I was attempting to "disect" the logic within the UDF to determine which aspect was causing the issue.
In the course of doing this, I executed a script to simply DROP & CREATE the UDF using its original definition.
After I did this, the performance went back to original levels (28 seconds down to 2 seconds). Are there some sort of plans/statistics maintained for UDFs like there are for tables? If so, can an UPDATE STATS like command be run against UDFs - I can't seem to find any references to this effect.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…