 |
 |
Archives of the TeradataForum
Message Posted: Mon, 28 Jul 2003 @ 13:03:03 GMT
| Subj: | | Re: The size of Volatile Tables |
| |
| From: | | Narayan Murthy K S |
The reason why I asked was, if you were to be sure that your interim data processing does in fact result in huge amount of rows most of
the time(or all the time), wouldn't it be cautious to go in for a permanent table than for a temporary table like volatile table, which does
not survive restarts or persist across sessions, logging only if explicitly specified, no permanent journaling and does not preserve rows
explicitly unless the PRESERVE clause is explicitly mentioned in the table definition.
Narayan.
| |
