sp_iqunusedtable procedure

Function

Reports IQ tables that were not referenced by the workload.

Syntax

sp_iqunusedtable 

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Description

Tables created in SYSTEM and local temporary tables are not reported.

Table 7-65: sp_iqunusedtable columns

Column name

Description

TableName

Table name

Owner

Username of table owner

Example

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

See also

“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