![]() |
Hi All,
07 May 2016
,
|
![]() |
As space saving initiative, we are applying BLC on certain tables in our Teradata system.
07 Feb 2016
| 3 comments
,
|
![]() |
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
11 Jul 2015
| 1 comment
,
|
![]() |
Hi,
17 Oct 2012
| 2 comments
,
|
![]() |
Hi all,
I tried to using BLC for the first time, but encountered some unusual case. One of my table cannot be compressed using BLC. Ferret says "The input table can't be compressed". why is that?
Thanks, Anung
31 Aug 2012
| 1 comment
,
|
![]() |
Go in-depth on how NULLs and Compression are managed in a Teradata system.
02 Mar 2012
,
|
![]() |
Teradata 13.10 features Block Level Compression (BLC), which provides the capability to perform compression on whole data blocks at the file system level before the data blocks are actually written to storage. Like any compression features, BLC helps save space and reduce I/O. This BLC utility is for Teradata users to run against TD 13.10 system to select the list of BLC candidate tables and evaluate BLC impact on space and speed for each specific table in interest, to get information for selecting appropriate tables to apply BLC.
13 Feb 2012
,
|
![]() |
Hi, what is the recommended update strategy for BLC tables? Scenario is to insert new rows - no deletes, no updates. Ulrich
29 Nov 2011
,
|
![]() |
Hi all,
18 Aug 2011
| 2 comments
,
|
![]() |
This session will focus on block-level compression (BLC), how it works, what compression rates you can expect, and where it is appropriate to define. Examples of the impact on CPU usage and elapsed time when queries access compressed tables will be shared, and the overhead while performing different database operations on these tables will be explored. Plenty of tips and techniques for successful use of BLC are offered.
24 Jan 2011
,
|
![]() |
One of the new compression features in Teradata 13.10 is Block Level Compression (BLC), which provides the capability to perform compression on whole data blocks at the file system level before the data blocks are actually written to storage. Like any compression features, BLC helps save space and reduce I/O. There is a CPU cost to perform compression on inserting data. And there is a CPU cost to perform decompression on whole data blocks whenever the compressed data blocks are accessed. Even when only one column of a single row is needed, the whole data block must be decompressed. For updates, the compressed data blocks have to be decompressed first and then recompressed. Careful evaluations shall be done before applying BLC in your production systems.
12 Jan 2011
| 7 comments
,
|