These Data Dictionary views report the count data.
| This view... | Provides this information... |
|---|---|
| ColumnsV[X] | AccessCount and LastAccessTimeStamp for selected columns. |
| DatabasesV[X] | AccessCount and LastAccessTimeStamp for selected databases. |
| IndicesV[X] | AccessCount and LastAccessTimeStamp for hash indexes or join indexes. |
| TablesV[X] | AccessCount and LastAccessTimeStamp for selected tables, views, macros, stored procedures, triggers, and functions. |
| Users | AccessCount and LastAccessTimeStamp for users that the requesting user owns or has MODIFY or DROP privileges on. |
| DatabaseUseCountV[X] | database use counts, by usage type. |
| ObjectUseCountV[X] | object use counts, by object usage type. |
| ColumnUseCountV[X] | column use counts, by usage type. |
| IndexUseCountV[X] | index use counts, by usage type. |
| StatUseCountV[X] | statistics use counts, by table and statistics. |
| QueryStatUseCountV[X] | query statistics use counts, by table and statistics. |
| UpdateUseCountV[X] | update count per table and column, by usage type. |
| DeleteUseCountV[X] | delete count per table, by usage type. |
| InsertUseCountV[X] | insert count per table, by usage type. |