QUERY CAPTURE FACILTIY (QCF) / QUERY CAPTURE DATABASE (QCD).

• It is TD DB facility that Captures the Data Pertaining to an Execution Plan and stores the data in set of relational tables in QCD.
• Provides the Foundation for TD Index Wizard & TD Visual Explain.
• Can store all Query Plans for customer queries.
• Provides Data so that we can do Analysis of Captured Query Steps.
• We can execute COLLECT, DROP & HELP STATISTICS SQL Statements against a QCD.