Determines whether block-level compression (BLC) compression ratio information is gathered by COLLECT STATISTICS statements, and can be displayed by the SHOW STATISTICS statement.
|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.|
Changes Take Effect
After the DBS Control Record has been written.
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.