Volitile and Global Temp Tables and the Transient Journal

Database
Enthusiast

Volitile and Global Temp Tables and the Transient Journal

Is transient journal overhead incurred on inserts/updates/deletes on volitile and global temp tables.? Thanks in advance.
4 REPLIES
Enthusiast

Re: Volitile and Global Temp Tables and the Transient Journal

Something to say? Add your comment here.
Enthusiast

Re: Volitile and Global Temp Tables and the Transient Journal

Something to say? Add your comment here.
Teradata Employee

Re: Volitile and Global Temp Tables and the Transient Journal

Logging is optional with volatile and global temporary tables. Specify NO LOG when creating the table if you don't want logging. See the SQL manual for details.

Re: Volitile and Global Temp Tables and the Transient Journal

Yes if you are specify LOG option , It will be have some overhead in the form of storing info in TJ of DBC perm space .