Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 11 Sep 2007 @ 14:36:43 GMT


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


Subj:   Re: MULTI VALUE COMPRESSION
 
From:   Tewksbury, Kevin

To follow up on this... the column "Compressvalue" only shows you the first value to be compressed for the column from the "compressvaluelist" column. As for "compressible", it does not appear to be correct, as I get a lot of columns with the "c" value and they are actually not columns that are compressed at all, so I used "AND compressvalue IS NOT NULL" instead. See below for creating the select count.

     SELECT 'select '||TRIM(columnname)||', COUNT(*) FROM
     '||TRIM(databasename)||'.'||TRIM(tablename)||' group by 1;'
     FROM dbc.COLUMNS
     WHERE  DatabaseName = ''
     AND compressvalue IS NOT NULL
     ORDER BY databasename, tablename, columnname

You could also add in:

     And Tablename = ''

If you just want a specific table.


Kevin R Tewksbury
Sr. Database Administrator
LimitedBrands



     
  <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