Archives of the TeradataForum

Message Posted: Mon, 28 Jul 2003 @ 13:03:03 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>