Archives of the TeradataForum

Message Posted: Wed, 03 Dec 2003 @ 16:15:29 GMT

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

When you issue the CREATE, an empty "model" table is created that uses a small amount of PermSpace (to hold table header blocks) in whichever database is used to qualify the table name. The qualification could be implicit / default or explicit in the CREATE, but the rule is the same.

When any user "X" references the GTT in a DML statement, an instance local to the current session will be materialized in the TempSpace for that referencing user "X".

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