15.00 - 15.10 - Query Capture Facility - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

The Query Capture Facility (QCF) allows you to capture the steps of query plan information into well-known user tables called the Query Capture Database (QCD).

The source of the captured data is produced by the Teradata Database Optimizer, which outputs the text of the EXPLAIN request modifier detailing the final stage of optimization.

Applications of QCF include:

  • Store all query plans for customer queries. You can then compare and contrast queries as a function of software release, hardware platform, and hardware configuration.
  • Provide data so that you can generate your own detailed analyses of captured query steps using standard SQL DML statements and third-party query management tools.
  • Provide the input for these utilities: Teradata Index Wizard (which recommends index definitions for improved efficiency) and Teradata VE (which presents a graphical view of the flow of data during query execution).