Archives of the TeradataForum

Message Posted: Thu, 04 Oct 2001 @ 14:54:04 GMT

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

Hi Ruth:

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).

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