Page tree

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.

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;