Typical Uses For Capacity Reclaimed By Multi-Value Compression
Following are some of the ways that reclaimed data capacity can be put to use:
On an existing system, the introduction of multi-value compression is not likely to
free a significant quantity of CPU resources. For those systems having residual CPU
capacity, the space savings from multi-value compression might permit more applications
to be introduced prior to the next system upgrade. If excess CPU capacity is already
exhausted, then alternative ways to use reclaimed capacity must be explored.
Perhaps the most obvious way to recycle newly liberated capacity is to keep more infrequently
accessed historical data online (see “Capacity Planning” on page 691).
Another way to use the reclaimed capacity is to improve system availability by declaring
fallback for some or all tables.
Alternatively, the excess capacity can be harnessed to improve performance by adding
new indexes to various SQL workloads (see SQL Request and Transaction Processing and Teradata Index Wizard User Guide for information about automatic evaluation of workloads to develop more high-performing