RE: SQL Deterministic UDF and File Read Count

>Am I correct that there would be one access to the UDF's table
 
Um, sort-of. You're correct that there *could* be only one access to the table, 
but the optimizer may have chosen to hit the table multiple times instead of 
caching the result, or it simply might not take deterministic into effect at 
all. Remember too, that if it's calling the same function multiple times with 
the same input I'm sure the function and all the needed rows are sitting in 
memory so it's not like it adds _that_ much time. 
 
The only things you can rest assured that SQL *will* do is return the records 
you asked for in the order you specified. Any assumptions on how SQL will run 
the query are best-guesses at best.
 
-Walden