>In Sql Server 2000 user defined functions do not make use of Indexes. I have a procedure that calls a function to get a balance in Sql Server 2000. This procedure takes 9 seconds to run. If i take whats in the function and do it inline in the procedure it drops down to one second. We use the function because this routine is used in many procedures and therefore if we have to make a change to it we would like for it to be in one location. My question is, if we upgrade to Sql Server 2005 does it remedy this issue? If not, is there a way to make a function make use of Indexes?

Mike, 2000/2005 same effect.

I'd like to know what your doing with your function and more importantly where in the query it's being used.

OTTOMH I guess that your running the function in getting the balance for hundreds or thousands of times instead of once for everyone, grouped properly.

I've seen this a lot.