Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 10 Sep 2007 @ 22:49:45 GMT


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


Subj:   MULTI VALUE COMPRESSION
 
From:   Gonela, Ram

Hi

I want to know whether there is any DBC view where I can see the no of values that are compressed against each COMPRESS VALUE that I define for table.

ExL I've defined MyDB.MyTable with following Column compressions:

MyDB.Mytable has Columns:

     QTR_CODE  CHAR(6)
           COMPRESS ('Q01','Q02','Q03','Q04','NOVAL')

     REGN_CODE CHAR(6)
           COMPRESS ('ESTCST','CNTRL','WSTCST','MIDWST','OTHR','NOVAL')

Result I am interested to see:

DatabaseName TableName ColumnName CompressValue NoOfCompressions MyDB MyTable QTR_CODE Q01 232209 MyDB MyTable QTR_CODE Q02 100 MyDB MyTable QTR_CODE Q03 3434543 MyDB MyTable QTR_CODE Q04 343 MyDB MyTable QTR_CODE NOVAL 345345 MyDB MyTable QTR_CODE NULL 423434345 MyDB MyTable REGN_CODE ESTCST 343 MyDB MyTable REGN_CODE CNTRL 34345 MyDB MyTable REGN_CODE WSTCST 67 MyDB MyTable REGN_CODE CNTRL 6564564 MyDB MyTable REGN_CODE MIDWST 5556 MyDB MyTable REGN_CODE OTHR 67656 MyDB MyTable REGN_CODE NOVAL 2323230 MyDB MyTable REGN_CODE NULL 212200000

Please let me know whether naybody can give me clue, how to obtain this information.


Thanks ,

Ram



     
  <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: 27 Dec 2016