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