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

On a system with 4 AMPs, you create a database with 1 gigabyte of spool space. The per-AMP quota of spool space is 250 megabytes. If you set the spool space skew limit to 20%, any AMP is allowed a skew limit of 50 megabytes over the per-AMP quota of spool space. An AMP can use up to 300 megabytes of spool space as long as total spool space used does not exceed the 1 gigabyte global limit for spool space.

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