With the Query Capture Facility (QCF), you can capture the steps of query plan information in user tables called the Query Capture Database (QCD).
The source of the captured data is produced by the Vantage Optimizer, which outputs the text of the EXPLAIN request modifier detailing the final stage of optimization.
QCF applications include the following:
- 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 you can generate your own detailed analyses of captured query steps using standard SQL DML statements and third-party query management tools.