I’m not sure if we’ve adjusted any standard IFS indexes, but we have certainly created our own indexes for IFS delivered tables that seem to work better in some cases.

With over 5 million rows in that index are you able to do any data cleanup of legacy data?

Nick

Did you try rebuilding the index again? There is a background job for this task in IFS Applications go to the scheduled database task window and search for Validate Index and Rebuild Indexes. Run the Validate indexes first and then Rebuild it. Check if you have any improvement through that as well.

Good thought but it didn’t change anything