Archives of the TeradataForum

Message Posted: Fri, 03 Dec 2004 @ 14:59:52 GMT

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

Anomy Anom:

Teradata has supported volatile and global temporary tables since release 3. A volatile table is materialized in SPOOL. Prior to release 5 you could have 64 volatile tables active at the same time; release 5 takes that up to either 1000 or 2000. You would probably run out of SPOOL before you were able to use this many volatile tables.

     Create Volatile Table mytable_vt ...

     insert into mytable_vt select ...

     sel * from mytable_vt
     where ....

Just that easy.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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