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.