one of the functions that i use is found to be non-deterministic function. So what does this mean w.r.t performance?
will this function be recompiled every time it is used?
this function uses data from 2 oltp tables which will have new records very often. so for the same input values if i get 10 records for first run i might get 15 in the second run because of inserts in the underlying tables. i also use date calculations inside the function which will make the function non-deterministic. But without date calculations should this function be termed non-deterministic because of changes in the output for same input values?