About Querying QCD Tables - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

You can analyze the information in QCD using several different approaches.

The following methods are typical ways to use a QCD to analyze query data.

  • To create and compare graphical EXPLAIN reports, use the Visual EXPLAIN tool.
  • To perform ad hoc requests of QCD, use interactive SQL DML statements.
  • To perform standardized analyses of QCD, create macros, stored procedures, or embedded SQL applications to perform your standard requests and report the results.
  • See “About QCD Request Macros and Views” on page 399 for a set of macros you can use for this purpose.

  • To run index validation diagnostics for the Teradata Index Wizard, use the DIAGNOSTIC “Validate Index” statement. See SQL Data Manipulation Language for the syntax of the DIAGNOSTIC “Validate Index” statement.