Reports IQ tables that were not referenced by the workload.
You must have EXECUTE privilege on the system procedure, as well as the MONITOR system privilege.
Tables created in SYSTEM and local temporary tables are not reported.
Column name |
Description |
---|---|
TableName |
Table name |
Owner |
User name 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