17.10 - IAMaxWorkloadCache - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Defines the maximum size of the workload cache when performing analysis operations. This field is applicable to both the INITIATE INDEX ANALYSIS and INITIATE PARTITION ANALYSIS statements.

Field Group

Performance

Valid Range

32 through 187 MB

Default

32 MB

Changes Take Effect

After the DBS Control Record has been written.