| DBQL Table | Performance Management Information |
|---|---|
| DBQLogTbl | Data on individual queries, including:
|
| DBQLSummaryTbl | A summary of short-running queries. For high-volume queries, it provides query origination, response time summaries, query counts, and CPU and logical I/O usage. |
| DBQLStepTbl | Query step timings, CPU and I/O usage, row counts, and step actions, among other things |
| DBQLObjTbl | Usage information about database objects such as tables, columns, indexes, and databases. |
| DBQLSqlTbl | The complete SQL text. |
| DBQLExplainTbl | EXPLAIN output. |
| DBQLXMLTbl | Query plans stored in Extensible Markup Language (XML). |