16.20 - Example: Using QryLogObjectsV - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

The following SELECT statement retrieves the object information of a query:

SELECT QueryID, ObjectDatabaseName (Named ObjDBName), ObjectTableName (Named ObjTblName), ObjectColumnName (Named ObjColName), ObjectID (Named ObjId), ObjectNum (Named ObjNum), ObjectType (Named ObjType), FreqofUse
FROM DBC.QryLogObjectsV where queryid = 201205134619838031;

Result:

QueryID            ObjDBName    ObjTblName  ObjColName ObjID    ObjNum   ObjType  FreqofUse
------------------ -----------  ----------  ---------- -------- -------  -------- ------
201205134619838031 D_PERSONNEL  ?            ?         00001604   0        DB      1
201205134619838031 D_PERSONNEL  DEPARTMENT   ?         00009005   0        Tab     1
201205134619838031 D_PERSONNEL  DEPARTMENT   DeptNo    00009005   1,025    Col     2
201205134619838031 D_PERSONNEL  DEPARTMENT   DeptName  00009005   1,026    Col     1
201205134619838031 D_PERSONNEL  DEPARTMENT   EmpCount  00009005   1,027    Col     1
201205134619838031 D_PERSONNEL  DEPARTMENT   Loc       00009005   1,028    Col     1