Reports IQ columns that were not referenced by the workload.
sp_iqunusedcolumn
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
Columns from tables created in SYSTEM or local temporary tables are not reported.
Column name |
Description |
|---|---|
TableName |
Table name |
ColumnName |
Column name |
Owner |
Username of column owner |
Sample output from the sp_iqunusedcolumn procedure:
TableName ColumnName Owner
SalesOrders ID GROUPO
SalesOrders CustomerID GROUPO
SalesOrders OrderDate GROUPO
SalesOrders FinancialCode GROUPO
SalesOrders Region GROUPO
SalesOrders SalesRepresentative GROUPO
SalesOrderItems ID GROUPO
SalesOrderItems LineID GROUPO
SalesOrderItems ProductID GROUPO
SalesOrderItems Quantity GROUPO
SalesOrderItems ShipDate GROUPO
Contacts ID GROUPO
Contacts Surname GROUPO
Contacts GivenName GROUPO
...
“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_iqunusedindex procedure”, “sp_iqunusedtable procedure”, and “sp_iqworkmon procedure”
“INDEX_ADVISOR option” in Chapter 2, “Database Options,” in Reference: Statements and Options
