 |
 |
Archives of the TeradataForum
Message Posted: Tue, 07 Sep 2004 @ 14:13:55 GMT
| Subj: | | Re: Global Temporary Table Rows |
| |
| From: | | Geoffrey Rommel |
| | In one of the teradata documents I read that the best solution to go for Global Temporary Tables is when multiple users want to access and
share the rows. But I also read that each user will be working on his own instance of Global Temporary Table, I am quite confused about the
meaning of sharing the rows. Can any one explain me what does this mean? | |
The *definition* of a Global Temporary Table is stored in the data dictionary, so all users will be sharing the same definition. Each user will
have his own instantiation, i.e. his own rows with data in them. Strictly speaking, if the GTT is defined with "on commit delete rows", each
transaction will begin a new instantiation; if with "on commit preserve rows", each session will.
| |
