15.00 - Typical Uses For Capacity Reclaimed By Multi-Value Compression - Teradata Database

Teradata Database Design

Teradata Database
User Guide

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 secondary indexes).