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:
More than one of these values can be used.
|