How can i find actul uncompress size of BLC Compress table

Database
Teradata Employee

How can i find actul uncompress size of BLC Compress table

Hi All,

I found some BLC compress tables in my system. I want to know what is the actul uncompress table size without uncompressing these tables.

Is there way to find this.?

Please suggest.

1 REPLY
Enthusiast

Re: How can i find actul uncompress size of BLC Compress table

Ferret's commands aplenty, showblocks, showcompress......estimate....

Need to balance the IO and CPU :).

If you need to see the size of table, then dbc.tablesize.