Archives of the TeradataForum

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

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

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