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. |