Views That Report Count Data
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. |