17.10 - Aggregate Cache and Aggregate UDFs - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

To enhance performance, Vantage caches intermediate aggregate storage areas. The size of the aggregate cache is fixed at 1 MB.

If the number of intermediate storage areas exceeds the capacity of the aggregate cache, Vantage pages the least recently used intermediate storage areas to a spool file on disk, which causes a larger number of aggregation phases to occur and impacts performance.

For details on improving aggregate cache usage for an aggregate UDF, including how to determine the maximum number of intermediate storage areas, see the information about CREATE FUNCTION in Teradata Vantageā„¢ - SQL Data Definition Language Syntax and Examples, B035-1144.