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.