Skip to main content

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)

 

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 

 


Reply