15.10 - LOG - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Transient journaling is performed for global temporary and volatile tables. This option only pertains to global temporary and volatile tables.

Updates, inserts, or deletes made to the global temporary or volatile table are logged in the transient journal. This is the default.

NO
Transient journal logging is not performed. Because the Teradata Database does not do any transient journaling, performance is greatly enhanced.
If an error or restart occurs and the table is defined as NO LOG, then any updates, inserts, or deletes made to the global temporary or volatile table cannot be recovered.
If the table is defined as NO LOG, contents of any materialized global temporary table or any volatile table are emptied when a transaction aborts.