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:
- Storing all query plans for customer queries. You can then compare and contrast queries as a function of software release, hardware platform, and hardware configuration.
- Providing 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.