Archives of the TeradataForum
Message Posted: Thu, 04 Oct 2001 @ 14:54:04 GMT
| Subj: || || Re: Removing columns |
| From: || || James LeBlanc |
Be cautious about stealing space from spoolreserve. That space is used by the transient journal during update, insert, delete
operations. One row is created in transient journal for insert/select into an empty table. This is one factor makes it so fast.
The concern comes about when you are doing what I described with tiny insert/selects into a populated table. That uses transient journal
space for each inserted row (to be released with the commit aka ET operation).