Category: Accounting
Database: DBC
View Column | Data Type | Format | Description |
---|---|---|---|
DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Database name of the object for which access count or UDI counts are recorded. |
TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the table whose column was accessed by a query. |
FieldName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Field name of a table if usage type is a DML type; StatsId if the usage is for statistics (the optimizer usage of statistics). |
UsageType | CHAR(3) LATIN UPPERCASE NOT NULL | X(3) | The usage type of the object (DML or STA). |
AccessCount | BIGINT | --,---,---,---,---,---,--9 | Number of accesses since the last reset by the user. |