[progress Communities] [progress Openedge Abl] Forum Post: Re: Index Performance For A Big...

  • Thread starter Thread starter Tim Kuehn
  • Start date Start date
Status
Not open for further replies.
T

Tim Kuehn

Guest
[quote user="ChUIMonster"] Perhaps the index suffers from (very) poor utilization. One possible source might be a large purge at some point. [/quote] The table had had a large purge of ~400M records at one point. An idxcompact on the index in question solved the problem - the lookup time went from ~5 min to an instant response.

Continue reading...
 
Status
Not open for further replies.
Back
Top