Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

From:   Gonela, Ram


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')


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 ,


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