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:
- Log on to the TSSADW_DW database.
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*