Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 04 Oct 2001 @ 15:00:44 GMT

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

Subj:   Re: Removing columns
From:   Eric J. Kohut

It might not be as bad as you think. Since we recommend that spool be set to 25 - 30 % of the system, you also have that space to leverage for your insert select. Between spool and perm you should have enough space to have two copies of your largest table. That is one copy in spool and one copy in perm space as duplication of your largest table. There are other alternatives to this approach which can reduce the overall space needed to 1 copy plus some overhead of your largest table. For example, extracting out your largest table to an external source file and then reloading, but this approach isn't what I would call attractive.

Good Luck,

Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.

  <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