15.10 - Chapter 7 Query Capture Facility - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
User Guide
featnum
B035-1142-151K

This chapter briefly describes the query capture database (QCD) that supports the various Database Query Analysis tools such as the Query Capture Facility, the Visual EXPLAIN utility, and the Teradata Database Index Wizard.

It also provides the definitions for the QCD tables. The physical implementation of QCD is presented here so you can create and perform your own queries and applications against the information it stores.

For information about using the Query Capture Facility, see Database Administration.

For information about the various query analysis tools and SQL statements that are relevant to the Query Capture Facility, see the following manuals.

  • Teradata Index Wizard User Guide
  • Teradata Viewpoint User Guide
  • Teradata Visual Explain User Guide
  • SQL Data Manipulation Language
  • COLLECT STATISTICS (QCD Form)
  • DROP STATISTICS (QCD Form)
  • DUMP EXPLAIN
  • INITIATE INDEX ANALYSIS
  • INITIATE PARTITION ANALYSIS
  • INSERT EXPLAIN
  • RESTART INDEX ANALYSIS
  • SQL Data Definition Language
  • BEGIN QUERY CAPTURE
  • Chapter 8: “The Teradata Index Wizard”