Are there tables that dont use the transient journal

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

Are there tables that dont use the transient journal

At partners last year i think i was in a session where they said there are new tables that dont use the transient journal.  not sure if its something new in 16 or if its avalable in 15.10.  I cant seem to find anything about them... but i do remember them talking about them.  It sounded like a special talbe kind of like a queue table where its defined when built and has special controles.

1 REPLY
Junior Contributor

Re: Are there tables that dont use the transient journal

It's probably the NO LOG option for temporary tables, i.e. only for Volatile or Global Temporary Tables.