Query Capture Facility - Advanced SQL Engine - Teradata Database

SQL Request and Transaction Processing

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
uqf1592445067244.ditamap
dita:ditavalPath
uqf1592445067244.ditaval
dita:id
B035-1142
lifecycle
previous
Product Category
Teradata Vantage™

This section briefly describes the query capture database (QCD) that supports the various Database Query Analysis tools such as the Query Capture Facility.

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 Teradata Vantage™ - Database Administration, B035-1093.

For information about the various query analysis tools and SQL statements that are relevant to the Query Capture Facility, see the following manuals:
  • Teradata® Viewpoint User Guide, B035-2206
  • Teradata Vantage™ - SQL Data Manipulation Language, B035-1146
    • COLLECT STATISTICS (QCD Form)
    • DROP STATISTICS (QCD Form)
    • DUMP EXPLAIN
    • INITIATE INDEX ANALYSIS
    • INITIATE PARTITION ANALYSIS
    • INSERT EXPLAIN
    • RESTART INDEX ANALYSIS
  • Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
    • BEGIN QUERY CAPTURE