Archives of the TeradataForum
Message Posted: Wed, 03 Dec 2003 @ 16:15:29 GMT
| Subj: || || Re: Global Temp Tables ?? |
| From: || || Fred W Pluebell |
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".