From the online books:
We have some functions that look things up in the database, and seem to work correctly. So I would be really surprised if this is true. |
As Breck indicated, "free to cache" means that the server may (or may not) re-execute the UDF when another invocation of the function is made with the same parameters. The server maintains an LRU cache of function parameters and the function's result, and will perform a look-aside into the cache before it goes to the effort of creating a new procedure context and re-executing the procedure. If you label a UDF as |