Reports IQ tables that were not referenced by the workload.
sp_iqunusedtable
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
Tables created in SYSTEM and local temporary tables are not reported.
Column name |
Description |
|---|---|
TableName |
Table name |
Owner |
Username of table owner |
The following table illustrates sample output from the sp_iqunusedtable procedure.
TableName Owner
FinancialCodes GROUPO
Contacts GROUPO
Employees GROUPO
emp1 DBA
SalesOrders GROUPO
FinancialData GROUPO
Departments GROUPO
SalesOrderItems GROUPO
Products GROUP
iq_dummy DBA
Customers GROUPO
sale DBA
“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_iqtableuse procedure”, “sp_iqunusedcolumn procedure”, “sp_iqunusedindex procedure”, and “sp_iqworkmon procedure”
“INDEX_ADVISOR option” in Chapter 2, “Database Options,” in Reference: Statements and Options
