Volitile and Global Temp Tables and the Transient Journal

Database

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

Re: Volitile and Global Temp Tables and the Transient Journal

Something to say? Add your comment here.

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 .