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 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 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*