17.00 - Example: Add Temporary Space Skew Limit to Database - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
Assume a system with 4 AMPs and a database with 1 gigabyte of temporary space. The per-AMP quota of temporary space is 250 megabytes. If you set the temporary skew limit to 20%, any AMP is allowed a skew limit of 50MB above the per-AMP quota of temporary space. An AMP can use up to 300 megabytes of temporary space as long as total temporary space used does not exceed the 1 gigabyte global limit for temporary space.
    MODIFY DATABASE d1 AS
    PERM = 1e9,
    TEMPORARY = 1e9 SKEW = 20 PERCENT;