16.10 - BLCStats - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval
dita:id
vkz1472241255652

Purpose

Determines whether block-level compression (BLC) compression ratio information is gathered by COLLECT STATISTICS statements, and can be displayed by the SHOW STATISTICS statement.

Field Group

Optimizer Statistics

Valid Settings

Setting Effect
0 Indicates field is set or has been reset to the Teradata default (enabled).

Equivalent to a setting of 1.

1 Enabled. BLC statistics are collected if BLC is enabled.
2 Disabled. BLC statistics are not collected.

Default

0 (enabled)

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

If BLC is enabled but BLC statistics are not wanted, set this field to 2 to reduce overhead of collecting such statistics on tables eligible for BLC.

The Ferret utility SHOWBLOCKS command also provides information on estimated compression ratios for BLC.

Related Topics

For more information on... See...
COLLECT STATISTICS and SHOW STATISTICS statements SQL Data Definition Language.
Enabling and disabling block-level compression BlockLevelCompression.
The Ferret Utility Ferret Utility (ferret)