17.05 - Query and Workload Analysis Statements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

These topics describe Teradata SQL DML statements used to collect or analyze data demographics and statistics. The collected data is used to populate user-defined QCD tables with data used by various Teradata utilities to analyze query workloads as part of the ongoing process to reengineer the database design process.

For information about query capture databases (QCDs), see Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142.

For information about Teradata data control language (DCL) statements, see Teradata Vantage™ - SQL Data Control Language, B035-1149.

For information about HELP and SHOW statements, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .

For information about database query logging, see Teradata Vantage™ - Database Administration, B035-1093.