Nontemporal Operations | Temporal Table Support | Teradata Vantage - 17.10 - Nontemporal Operations - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Temporal Table Support

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

A nontemporal operation is an operation where the NONTEMPORAL prefix is used with an ALTER TABLE, CREATE TABLE AS (Copy Table Syntax), DELETE, INSERT, or UPDATE statement. Nontemporal operations allow modifications to be made to closed rows in transaction-time and bitemporal tables which are normally not allowed on tables with transaction time. These operations can circumvent the automatic history that is normally kept for these kinds of temporal tables. They can specify a transaction time when modifying and inserting rows, and can physically delete closed rows. These operations are normally not allowed on temporal tables that have transaction time. Use of the NONTEMPORAL keyword is discouraged in most situations, and requires the special NONTEMPORAL privilege. For more information see Usage Notes.