Hi,
Our DBA warned us about the fragmentation of the HFM indexes (above 90% for several tables).
My first approach was to use the HFM Index Update Utility, which by the way is really hard to find, because only the latest version works with HFM 11.1.2.1. As soon as I ran the first report it was clear to me that it does nothing about fragmentation, it just compare the construct of the indexes against a default definition.
Which is the best way to handle this?
Any specific scripts for this or just executing the index rebuild statement from SQL Server?
Thank you.