There is new utility in HFM 220.127.116.11.500 – PSE 18921957– It checks the corresponding HFM database and reports the index issues and its corresponding actions to be taken!
In a recent patch set update, Oracle provides a new utility that will analyze HFM Indexes.
This is for release 18.104.22.168.500 via Patch Set Exception (PSE): 18921957. However, you can use this utility on any 11.1.2.x version. The patch:
- Examines the indexes on the database tables and compare them against the required indexes to see if any changes should be made
- Can be used to repair an issue that may have been caused by certain versions of the HFM Copy Application utility
Link to the patch: https://updates.oracle.com/Orion/Services/download?type=readme&aru=18120702
“The index update utility operates in three modes. The first is to examine the existing database table indexes on an HFM application and generate a report outline any potential problems that may exist. The second option will generate a report and a file of SQL commands to drop and recreate any possibly missing or incorrect indexes. The third form generates a report and instantly executes the commands to drop/recreate indexes.”
Blog by Prakash Chandran of Key Performance Ideas