Archives of the TeradataForum
Message Posted: Thu, 06 Feb 2003 @ 20:14:27 GMT
Subj: | | Re: Volatile vs. Global |
|
From: | | Dieter N�th |
Anomy Anom wrote:
| Another difference may be in the use of transient journaling. Volatile tables do not (I believe) use TJ. I do not know about Global.
Can anyone can correct my info? | |
Both use TJ unless you specify the NO LOG option.
Other differences: Global temp tables are typically created in a shared database by administrative users and not by end users.
But an end user can create a volatile table even if he has no perm (space but still needs the Create Table right).
Dieter
|