My SolarWinds Database Performance Analyzer is reporting some specific indexing issues.
This one caused 41m 25s of wait time in 63 different queries
I wonder if anyone has had any success tweaking indexes in IFS?
Index: MATERIAL_HISTORY_IX2 (in IFSAPP)
+18
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
+15
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
