Example: Using Constant Expression to Specify TEMPORARY Space for Profile - Advanced SQL Engine - Teradata Database

The following statement creates a profile with the amount of TEMPORARY space based on the constant expression 2,000,000 * (HASHAMP() +1). The expression calculates the number of AMPs in the current system and scales the TEMPORARY space for the research_and_development profile to that size.

CREATE PROFILE research_and_development AS 
DEFAULT DATABASE = it_dev, 
PASSWORD = (EXPIRE = 0), 
TEMPORARY = 2000000*(HASHAMP()+1);