All Forums Database
sashi1985 1 post Joined 02/12
17 Oct 2012
How to identify tables that have been Block-level compressed using SQL

Hi,
Please can some tell me how to identify tables that have been Block-level compressed using SQL.
Hopefully from one of the DBC. <tables>.
 
Note: I do not have access to Ferret tool or anyother tools an admin has access to.

Tags:
pawan0608 101 posts Joined 12/07
18 Oct 2012

I guess, DBC tables don't store that information.

Subbu99 4 posts Joined 05/05
01 Sep 2016

In TD15.10, below SQL will reveal if there is BLC on the table.
show stats values on <databasename.tablename>;
 
BLCPctCompressed > 0 in the answerset will indicate BLC is on.

Thanks,
Subbu

You must sign in to leave a comment.