Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Removing columns
From:   James LeBlanc

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020