I am reading on post and is about "are stored procedures faster than functions or not".
Link :
http://stackoverflow.com/questions/1979319/are-stored-procedures-faster-than-functions-or-not I got the answer saying that functions are much slower then sp.
Now my question is why functions are slower then stored procedures?
Is this because of Stored procedure are precompiled objects. so execution time is much better than functions?