The following table lists the fields populated in an objects row.
|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:
More than one of these values can be used.