Nontemporal Operations - Analytics Database - Teradata Vantage

To allow operations that are otherwise not allowed on tables with transaction time, statements can specify the NONTEMPORAL prefix. Such operations on tables with transaction time require the NONTEMPORAL privilege.

Here is an example that grants the NONTEMPORAL privilege to user simon573 on a transaction-time table named Policy_Types:

GRANT NONTEMPORAL ON Policy_Types TO simon573;

To disable all nontemporal operations, use the EnabNonTempoOp field of the DBS Control utility.

For details on the DBS Control utility, see Teradata Vantage™ - Database Utilities, B035-1102.