17.10 - Deterministic Characteristics Clause - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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

Vantage supports the following deterministic characteristics options:

Vantage 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.