How to identify tables that have been Block-level compressed using SQL

Database

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 (1)
2 REPLIES
Enthusiast

Re: How to identify tables that have been Block-level compressed using SQL

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

Enthusiast

Re: How to identify tables that have been Block-level compressed using SQL

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.