Example: Creating a Database with a Temporary Space Skew Limit - Analytics Database - Teradata Vantage

For a system with 4 AMPs, you create 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 more than 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.

CREATE DATABASE d1 AS
PERM = 1e9,
TEMPORARY = 1e9 SKEW = 20 PERCENT;