Skip to Content
Information
Important This space contains documentation for TrueSight Smart Reporting for Server Automation 20.02.01. For earlier releases, see TrueSight Smart Reporting for Sever Automation 19.2.

Unusable indexes in the data warehouse

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

Workaround: The DBA must verify that the data warehouse contains unusable indexes. If the 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;

Contact BMC support if you still face any performance issues.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

TrueSight Smart Reporting for Server Automation 20.02.01