Reports detailed usage information for tables accessed by the workload.
sp_iqtableuse
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
Tables created in SYSTEM are not reported.
Column name |
Description |
|---|---|
TableName |
Table name |
Owner |
Username of table owner |
UID** |
Table unique identifier |
LastDT |
Date/time of last access |
NRef |
Number of query references |
**UID is a number assigned by the system that uniquely identifies the instance of the table (where instance is defined when an object is created).
“Monitoring workloads,”Chapter 3, “Optimizing Queries and Deletions,” in the Performance and Tuning Guide.
“sp_iqcolumnuse procedure”, “sp_iqdbspace procedure”, “sp_iqindexadvice procedure”, “sp_iqindexuse procedure”, “sp_iqunusedcolumn procedure”, “sp_iqunusedindex procedure”, “sp_iqunusedtable procedure”, and “sp_iqworkmon procedure”
“INDEX_ADVISOR option” in Chapter 2, “Database Options,” in Reference: Statements and Options
