There is at least one view for each DBQL table. These views are created in database DBC when the Environment is created. For more information, contact Teradata Support.
| Dictionary Object | Purpose |
|---|---|
| DBQLRules[V] | Displays the current rules in DBC.DBQLRuleTbl (to a user with DBC or SystemFE privileges). |
| QryLockLogXML[V] | Accesses the DBQLXMLLockTbl. |
| QryLogExplainDoc[V] | Accesses the DBQLExplainTbl and provides a single, readable document per query. |
| QryLogExplain[V] | Accesses the DBQLExplainTbl. In VantageCloud Lake, there are additional views in td_metric_svc database. See dbqlexplainV . |
| QryLogFeatureListV | Accesses the FeatureNames table function, SYSLIB.FeatureNames_TBF(). |
| QryLogFeatureUseCountV | Accesses the FeatureUsage column of DBQLogTbl and the QryLogFeatureList view. |
| QryLogFeatureUseJSON | Accesses the FeatureUsage column of DBQLogTbl and, in a JSON document, lists the features used by a request. |
| QryLogObjects[V] | Accesses DBQLObjTbl, and logs one row for each time an object is referenced by a query. In VantageCloud Lake, there are additional views in td_metric_svc database. See dbqlobjV . |
| QryLogParamV | Accesses the parameterized query log table, DBQLParamTbl. |
| QryLogParamJSON | Accesses the parameterized query log table, DBQLParamTbl, in JSON format. |
| QryLogSQLDoc[V] | Accesses the DBQLSQLTbl and combines multiple rows of SQL text information with the same queryid into one document. |
| QryLogSQL[V] | Accesses the DBQLSQLTbl. In VantageCloud Lake, there are additional views in td_metric_svc database. See dbqlsqlV . |
| QryLogSteps[V] | Accesses the DBQLStepTbl. In VantageCloud Lake, there are additional views in td_metric_svc database. See dbqlstepV . |
| QryLogSummary[V] | Accesses the DBQLSummaryTbl. In VantageCloud Lake, there are additional views in td_metric_svc database. See dbqlsummaryV . |
| QryLogTDWM[V] | The Teradata Dynamic Workload Management view of the default log table, DBQLogTbl. |
| QryLog[V] | Accesses the DBQLogTbl and contains the default DBQL information for a query. In VantageCloud Lake, there are additional views in td_metric_svc database. See dbqlogV . |
| QryLogUtilityV | Accesses the DBQLUtilityTbl. In VantageCloud Lake, there are additional views in td_metric_svc database. See dbqlutilityV . |
| QryLogXMLDocV | Accesses the DBQLXMLTbl. Teradata recommends using this view instead of QryLogXML[V] to make sure your applications remain compatible with future enhancements. |
| QryLogXML[V] | Accesses the DBQLXMLTbl. |
The DBQL views are predefined for ease of use. However, database administrators can create customized views by taking data from one or more DBQL tables and displaying the information in the desired format.