Example: Creating a Database with a Spool Space Skew Limit - Advanced SQL Engine - Teradata 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;