15.00 - Determining How Much Table Header Space is Used for Compression - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Determining How Much Table Header Space is Used for Compression

The following procedure is an easy way to determine how much table header space is used for a particular set of column multi-value compressions.

1 Create two unpopulated tables that are identical except that one is defined with compression and the other without.

2 Perform the following query against both empty tables.

     SELECT CurrentPerm
     FROM DBC.TablesizeV
     WHERE TableName = ’table_name’;

where table_name is the name of the compressed or uncompressed table.

3 Perform the following calculation.

The result is the space in bytes used for multi-value compression in the table header.