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 Teradata utilities to analyze query workloads as part of the ongoing process to reengineer the database design process.
- COLLECT DEMOGRAPHICS
- COLLECT STATISTICS (QCD Form)
- DROP STATISTICS (QCD Form)
- DUMP EXPLAIN
- EXPLAIN Request Modifier
- INITIATE INDEX ANALYSIS
- INITIATE PARTITION ANALYSIS
- INSERT EXPLAIN
- RESTART INDEX ANALYSIS
For information about query capture databases (QCDs), see Query Capture Facility.
For information about Teradata data control language (DCL) statements, see SQL Data Control Language.
For information about HELP and SHOW statements, see SQL HELP Statements and SQL SHOW Statements.
For information about database query logging, see Tracking Query Behavior with Database Query Logging: Operational DBAs.