Archives of the TeradataForum
Message Posted: Wed, 27 Mar 2013 @ 23:48:17 GMT
| Subj: || || Re: How to bypass Transient journal |
| From: || || Anomy Anom |
<-- Anonymously Posted: Wednesday, March 27, 2013 17:44 -->
What is the real issue? Why do you think you want to bypass TJ? Overhead for TJ is much less these days than it was prior to introduction of
WAL in V2R6.2.
TJ is not used for temporary tables (VOLATILE or instance of GLOBAL TEMP) created with NO LOG. And some utilities (e.g. MultiLoad) don't use
normal SQL protocol and so bypass TJ - but they impose other significant restrictions.