Unusable indexes in the reports data warehouse

On Oracle databases, product performance can be impacted by unusable indexes in the reports data warehouse.

Workaround: The DBA must verify that the reports data warehouse contains unusable indexes. If the reports data warehouse contains unusable indexes, perform the following steps:

1. Log on to the TSSADW_DW database.

2. Run the REBUILD_UNUSABLE_INDEXES procedure as follows:

   BEGIN 
   REBUILD_UNUSABLE_INDEXES; 
   END;