15.00 - Percent Savings Realizable With 20% Multi-Value Compression - Teradata Database

Teradata Database Design

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

Percent Savings Realizable With 20% Multi-Value Compression

The following table indicates the percentage of savings that can be realized when 20% of the subject rows can be multi‑value compressed. A MINUS sign indicates net capacity expansion rather than savings.

 

Number of Values

Column Width (bytes)

2

4

8

16

1

14

17

18

19

3

7

14

17

18

7

1

11

15

18

15

-

7

14

17

31

-

4

12

16

63

-

1

11

15

127

-

-

9

15

255

-

-

7

14