Like the DECIMAL/NUMERIC data type, the INTEGER family of data types offers different levels of precision that you can harness to reduce the number of bytes used to store integer numbers.
The following table indicates the number of bytes used to store integer numbers of precisions:
Integer Data Type | Number of Bytes Stored |
---|---|
BYTEINT | 1 |
SMALLINT | 2 |
INTEGER | 4 |
BIGINT | 8 |
You can achieve optimal space savings by using multivalue compression with an efficient integer data type. For example, define the precision to use a one-byte representation instead of a four-byte representation: for example, BYTEINT instead of INTEGER. Then multivalue compression can be used on the most frequently occurring values to further reduce the storage overhead.