Aggregate Cache and Aggregate UDFs - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantageā„¢

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.