16.10 - Row Values - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

The following table lists the fields populated in an objects row.

DBC.DBQLObjTbl Field Description
CollectTimeStamp Time that the rows were written to the database. This field is also part of the multi-column NUPI (see also ProcID).

For more information on CollectTimeStamp, see Comparing CollectTimeStamp Value Between Tables.

FreqofUse Number of times the object was accessed, as determined by the Optimizer, to process the query.
ObjectColumnName Name of the column. Or if the ObjectType is 'Idx' or Index, this field returns the name of the column associated with the index.

Some queries will not provide a name, such as COLLECT STATISTICS.

For multicolumn indexes, there will be one additional row for each column in the index and each row will have the same object number.

ObjectDatabaseName Name of the database that owns the target object.
ObjectID Unique internal identifier of this object.
ObjectNum Number of the column or secondary index.
ObjectTableName Name of the table or view.
ObjectType Character code indicating the type of object targeted.

For the possible values for this column, see ObjectType Column Values.

ProcID Unique processor ID of the Dispatcher and part of the multi-column NUPI (see also CollectTimeStamp).
QueryID Internally-generated identifier of the query.
QueryID is a system-wide unique field; You can use QueryID to join DBQL tables or the DBC.TdwmExceptionLog table with DBQL tables without needing ProcID as an additional join field.
TypeOfUse Describes the use of the object. TypeOfUse contains the following numerical values:
  • 1 = Found in the resolver
  • 2 = Accessed during query processing
  • 4 = Found in a conditional context
  • 8 = Found in inner join condition
  • 16 = Found in outer join condition
  • 32 = Found in a sum node
  • 64 = Found in a full outer join condition
More than one of these values can be used.