Category: Accounting
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The database name of the object for which access count or UDI counts are recorded. |
| TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the table whose index was used for a request. |
| IndexName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of an index which got accessed for a query. |
| IndexNumber | SMALLINT NOT NULL | ---,--9 | The primary or secondary index of a table used for table access. |
| 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. |