Wednesday, July 19, 2023

SQL Server - Adverse effect of using User defined function in the T-SQL Query Performance

Following are the reaons that why UDF degrade query performance:
1) User defined function calls each row & get the data for it which will degrade the query performance.
2) In case of large volume of data, It will be very very slow.
3) The index is not used by the database if there is a function on the column.


No comments:

Post a Comment