The Query Capture Facility is a Database Query Analysis tool supported by the query capture database (QCD). QCD provides the definitions for the QCD tables.
This section describes the physical implementation of QCD so you can create and perform your own queries and applications against its information.
- Quick Functional Overview of the Query Capture Facility
- QCD Table Definitions
- AnalysisLog
- AnalysisStmts
- DataDemographics
- Field
- Index_Field
- IndexColumns
- IndexMaintenance
- IndexRecommendations
- IndexTable
- JoinIndexColumns
- Partition Recommendations
- Predicate
- Predicate_Field
- QryRelX
- Query
- QueryBandTbl
- QuerySteps
- RangePartExpr
- Relation
- SeqNumber
- SingleRowRelation
- StatsRecs
- TableStatistics
- User_Database
- ViewTable
- Workload
See Query Capture Facility for an overview..
For information about the query analysis tools and SQL statements that are relevant to the Query Capture Facility, see the following topics:
DUMP EXPLAIN, INSERT EXPLAIN. INITIATE INDEX ANALYSIS, and INDEX PARTITION ANALYSIS are supported only on the Block File System on the primary cluster, not on the Object File System.