Archives of the TeradataForum

Message Posted: Mon, 28 Jul 2003 @ 18:01:03 GMT

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

Craig,

You have the right idea. Volatile tables can be used for Anything that a normal table is used for. It can be of Any size.

The only downside is that you can't collect statistics on Them.

The upside is that there is no transient journal used for Volatile tables so that many DML statements like insert, Update and delete against populated (volatile) tables Run faster than regular tables.

Eric

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