In theory this means the database can apply additional optimizations when it knows a deterministic UDF is being used. Unfortunately, SQL Server ... plan, you should see no difference between a ...