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 example, the Teradata Index Wizard determines optimal secondary and single-table join index sets to support your query workloads.
For information about query capture databases (QCDs), see Teradata Vantage™ SQL Request and Transaction Processing, B035-1142.
- Teradata® Index Wizard User Guide, B035-2506
- Teradata Vantage™ SQL Request and Transaction Processing, B035-1142
For information about Teradata Database 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.