Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Unusable indexes in data warehouse

On Oracle databases, the product performance might be down due to unusable indexes in the 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 BSARA_DW database.

  2. Run the REBUILD_UNUSABLE_INDEXES procedure as follows: 

    BEGIN 
    REBUILD_UNUSABLE_INDEXES; 
    END;

 

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