15.00 - Deterministic Characteristics Clause - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Deterministic Characteristics Clause

This optional clause declares whether the function returns the same results for identical inputs or not.

Teradata Database supports two deterministic characteristics options:

  • DETERMINISTIC
  • NOT DETERMINISTIC
  • Teradata Database must evaluate each row selected by a non‑deterministic 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 non‑deterministic UDF specified on an index results in an all‑AMP operation in spite of the index having been specified in the predicate.