Database Profiles | SQL Fundamentals | Teradata Vantage - 17.10 - Profiles - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Fundamentals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
Profiles define values for the following system parameters:
  • Default database
  • Spool space
  • Temporary space
  • Default account and alternate accounts
  • Password security attributes
  • Optimizer cost profile
    Optimizer cost profiles are not intended for use on production systems. The Cost Profile parameter is for use only under the direction of Teradata Support Center personnel.
  • Query band

An administrator can define a profile and assign it to a group of users who share the same settings.