16.10 - CPU Considerations on Different Teradata Platforms - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
User Guide
Publication ID
B035-1094-161K
Language
English (United States)

Because software-based BLC is CPU-intensive, consider the CPU capabilities of the particular Teradata Database platform when using it. When using BLC on Teradata appliance systems with a very high CPU capacity, you can:

  • Apply BLC to all allowable types of data.
  • Load and access data at any time, because there is enough available CPU to frequently decompress data.

When using software-based BLC on other platforms with less CPU capacity, you may need to:

  • Load tables during off-peak hours.
  • Limit access to compressed tables during critical throughput periods.

Some operations (including queries, insert/updates, ARC dump/restores, reconfig, and CheckTable) can use considerably more CPU while operating on compressed tables. Unless the system is very CPU rich, these operations will impact other workloads and could lengthen elapsed response times.