Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 Sep 2002 @ 14:03:39 GMT


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


Subj:   Verifying Column Compression
 
From:   Tony Howe

Is there anyway to tell if a new column being added to the end of a table that's marked as NOT NULL DEFAULT ' ' COMPRESS ' ' is actually getting compressed.

I do an INSERT/SELECT from CURRENT to NEW table and new table has 15 new columns added to the end define as above. I usually don't see an increase in DASD use, but this time the table size increased by 54 GB as if compression didn't happen on the new columns.


Thanks in advance, Tony.

Anthony S. Howe
Teradata/DB2 Database Administrator
Highmark Blue Cross/Blue Shield



     
  <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