This optional clause declares whether the function returns the same results for identical inputs or not.
Teradata Database supports two deterministic characteristics options:
- NOT DETERMINISTIC
Teradata Database must evaluate each row selected by a nondeterministic UDF condition individually because the evaluation of the function can change for each row selected within a query. This qualification includes both specifying NOT DETERMINISTIC explicitly and not specifying DETERMINISTIC, because NOT DETERMINISTIC is the default option for the clause.
A predicate that includes a nondeterministic UDF specified on an index results in an all-AMP operation in spite of the index having been specified in the predicate.