16.10 - About Querying QCD Tables - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

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.
  • 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.