Understanding BLC features

Database
Enthusiast

Understanding BLC features

I have few questions on BLC(Block Level Compression):

a) Can a table be partially compressed using BLC and partially

remain uncompressed?If this is true, how to know if 

a table is partially compressed using BLC.

b) Does stats collection on a table compressed using BLC

take more CPU and IO resources than the equivalent uncompressed table?

Can someone answer and  help me understand.

Thanks in Advance

Tags (1)
1 REPLY
Enthusiast

Re: Understanding BLC features

Hi,

A)See below link hope it will help.

http://tinyurl.com/p3cu24l

Compression in Teradata - by Carrie Ballinger (Orange Book)

I read it on one of the orange book.

B).Statistics collection in general will get somewhat longer and will require more CPU when issued against a compressed table.