Archives of the TeradataForum

Message Posted: Thu, 10 Mar 2011 @ 12:17:31 GMT


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

Subj:		Re: Maximum number of Volatile tables in a session

From:		Dieter Noeth

Mukardamwala Suhel wrote:

What is maximum number of volatile tables can be created in a particular session?

1000 + 2000 materialized global temp tables

How to find the number of volatile tables in a particular session?

     HELP VOLATILE TABLE;

returns the list of volatile tables

Dieter


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

Archives

2011 Indexes

Last Modified: 15 Jun 2023