Skip to main content
Question

Oracle Index issues


Forum|alt.badge.img+9

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)

 

3 replies

NickPorter
Superhero (Customer)
Forum|alt.badge.img+18
  • Superhero (Customer)
  • 354 replies
  • July 8, 2020

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


Ragaventhan Sathananda
Superhero (Partner)
Forum|alt.badge.img+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.


Forum|alt.badge.img+9
  • Author
  • Do Gooder (Customer)
  • 53 replies
  • July 8, 2020

Good thought but it didn’t change anything 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings