All Forums Database
Kishore_1 208 posts Joined 03/10
11 Jul 2015
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:
arpitsinha 13 posts Joined 06/15
13 Jul 2015

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.

 

Regards, Arpit

You must sign in to leave a comment.