Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 04 Oct 2001 @ 19:56:49 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Removing columns
From:   Ken Hansen

Insert select into empty table is undoubtedly the best - for the reasons already detailed but it does not follow that you need as much space as the table takes at present: The indexes on the current table are likely to take significant space.

That subject was covered by emails in this forum, quite recently. but to summarise: Insert into a table without indexes and possibly create space by dropping the indexes on the original table first. Then recreate the indexes after you've dropped the redundant table. The subject of indexes

Good luck.

Ken Hansen
Ivy House Associates

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020