sp_iqunusedindex Procedure

Reports IQ secondary (non-FP) indexes that were not referenced by the workload.

Syntax

sp_iqunusedindex

Permissions

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

Description

Indexes from tables created in SYSTEM or local temporary tables are not reported.

sp_iqunusedindex columns
Column name	Description
IndexName	Index name
TableName	Table name
Owner	User name of index owner
IndexType	Index type

Example

Sample output from the sp_iqunusedindex procedure:

IndexName TableName Owner IndexType ASIQ_IDX_T450_I7_HG SalesOrders GROUPO HG ASIQ_IDX_T450_C6_HG SalesOrders GROUPO HG ASIQ_IDX_T450_C4_HG SalesOrders GROUPO HG ASIQ_IDX_T450_C2_HG SalesOrders GROUPO HG ASIQ_IDX_T451_I6_HG SalesOrderItems GROUPO HG ASIQ_IDX_T451_C3_HG SalesOrderItems GROUPO HG ASIQ_IDX_T451_C1_HG SalesOrderItems GROUPO HG ASIQ_IDX_T452_I11_HG Contacts GROUPO HG ASIQ_IDX_T453_I10_HG Contacts GROUPO HG ASIQ_IDX_T454_I4_HG FinancialCodes GROUPO HG ASIQ_IDX_T455_I5_HG FinancialData GROUPO HG ASIQ_IDX_T455_C3_HG FinancialData GROUPO HG ASIQ_IDX_T456_I8_HG Products GROUPO HG ASIQ_IDX_T457_I4_HG Departments GROUPO HG ASIQ_IDX_T457_C3_HG Departments GROUPO HG ASIQ_IDX_T458_I21_HG Departments GROUPO HG ASIQ_IDX_T458_C5_HG Departments GROUPO HG