Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 05 Dec 2003 @ 20:10:09 GMT


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


Subj:   Re: Alter table compression
 
From:   Victor Sokovin

I believe you can use 'alter table' to add single value compression if you did't have it yet. In addition to that, you might be able to change the compression value if the change does not affect the data. For example, if you have the compression value of 'A' and this value does not occur in the column at all, then you might be able to change the value to, say, 'B' using 'alter table'.

I did not try multivalue compression as yet but it looks like you cannot add or alter it using 'alter table'.

You can find the 'alter table' syntax in RDBMS Ref Vol. 4, Ch.1.

Having said that I want to add that I would go for the INSERT ... SELECT into a new table rather than use 'alter table' in these cases. Just to stay on the safe side and make sure that the data distribution is optimal.


Regards,

Victor



     
  <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: 15 Jun 2023